Solved

Excel 2010 - Date time to integer

Posted on 2011-03-14
3
199 Views
Last Modified: 2012-05-11
Team,

I have multiple rows with a field, Date which has value like these:

3/1/2011 21:53
3/1/2011 22:39
3/1/2011 22:46

Based on certain criteria, i need to find the difference between two dates.

Assuming, I am finding the difference between 3/1/2011 21:53 & 3/1/2011 22:39

(3/1/2011 22:39) - (3/1/2011 21:53) gives me 0.03181713 as result in Excel 2010. Technically, the difference is 45 Mins & 49 seconds.

Is there anyway, i can use a formula which will give me a int value? ~45

as in,

(3/1/2011 22:39) - (3/1/2011 21:53) should give me 45 as result

Kindly help


0
Comment
Question by:davidi1
  • 2
3 Comments
 
LVL 22

Expert Comment

by:rspahitz
ID: 35132994
Since you're converting days into minutes, you'd get:

=A1*24*60
0
 
LVL 22

Accepted Solution

by:
rspahitz earned 500 total points
ID: 35133003
or I guess:

=(A2-A1) * 24 * 60
0
 

Expert Comment

by:pakachele
ID: 35133171
This should solve your purpose : =MINUTE(A2 - A1)
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question