Hours between date/Time

B

Brooks W.

I have information in the following format:

A1 - 2/29/2008 15:00:00 PM
B1 - 3/3/2008 3:42:00 AM

I am trying to calculate the hours in between and come up with a numeric
value (ie 47). The data come to me in this format from another application.

Thanks for the help
 
M

Mike H

Maybe

=B1-A1

Formatted as [hh]:mm

but it will give an answer of 60:42, why do you think it should be 47?

Mike
 
T

Tyro

If you're looking for the time difference, the formula is =B1-A1 formatted
as [h]:mm:ss In this case the result is 60:42:00
Or did you want just the hours which would be
=INT(B1-A1)*24+INT(((B1-A1)-INT(B1-A1))*24) formatted as general In this
case the result is 60

Tyro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separating date and time 5
Calculate elapsed time excluding specific timeframe 10
How toFind the Time difference in hours 2
Work Hours 1
WORK HOURS DIFFERENCE BETWEEN TWO DATES 12
Subtracting time...again 2
IF(M2="","",(NETWORKDAYS(F2,M2))+TIME(17,0,0)-F2+M2-TIME(8,0,0)) 7
Hours between to two times 3

Top