Calculating time

L

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.
 
L

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
 
F

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.
 
Top