Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel 2010 - Date time to integer

Posted on 2011-03-14
3
Medium Priority
?
207 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

609 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