Hours between date/Time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brooks W. - 04 Mar 2008 15:55 GMT

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

Signature

Brooks W.

Reply to this Message

Mike H - 04 Mar 2008 16:08 GMT

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

> I have information in the following format:
>
[quoted text clipped - 5 lines]
>
> Thanks for the help

Reply to this Message

Tyro - 04 Mar 2008 16:21 GMT

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

>I have information in the following format:
>
[quoted text clipped - 6 lines]
>
> Thanks for the help

Reply to this Message