Calculating time
 

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.

Calculating time
 

=mod(b1-a1,1)*24

Format as general, or a number

Regards,
Fred.

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

Calculating time
 

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" wrote:

=mod(b1-a1,1)*24

Format as general, or a number

Regards,
Fred.

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

Calculating time
 

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

Regards,
Fred.



"Lost" wrote in message
...
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" wrote:

=mod(b1-a1,1)*24

Format as general, or a number

Regards,
Fred.

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