Hours between date/Time

  • Thread starter Thread starter Brooks W.
  • Start date Start date
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
 
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
 
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
 
Back
Top