Hours between date/Time
 

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
--
Brooks W.

Hours between date/Time
 

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



"Brooks W." wrote:

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
--
Brooks W.

Hours between date/Time
 

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

"Brooks W." wrote in message
...
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
--
Brooks W.