Solved

Excel 2010 - Date time to integer

Posted on 2011-03-14
3
198 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

785 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