Calculating time

[Lost]

Hi everyone,

I need to figure out how to calculate time, as in 9:00pm - 1:30am =
4.5hours. The issue im running into is crossing the midnight threshold.

 

[Fred Smith]

=mod(b1-a1,1)*24

Format as general, or a number

Regards,
Fred.

 

[Lost]

Thanks it worked kinda.... i needed to change it a bit to
=24-(mod(b1-a1,1)*24)
otherwise it gave me the result of 20.0

But thank you very much!!!! your a peach

 

[Fred Smith]

That would be because you are calculating StartTime - EndTime. I had assumed
you would do it the standard way: EndTime - StartTime.

Regards,
Fred.