Time formulas

  • Thread starter Thread starter Tom S
  • Start date Start date
T

Tom S

How do I make a formula for a time that starts at night, (23:30) and ends the
following day (09:00) and come out to be 12.5???? I can make it work for
times on the same day like (09:00 and ends at 23:00) and it shows up as 12.5.
I don't want to have to use a date along with the tme. I sure hope there is
a way to make it work.
 
It should be 9.5, *not* 12.5

Start time in A1,
End time in B1,

In C1:
=Mod(B1-A1,1)*24

With C1 formatted to General or Number.
 
Thanks, looks like it is working for me

Ragdyer said:
It should be 9.5, *not* 12.5

Start time in A1,
End time in B1,

In C1:
=Mod(B1-A1,1)*24

With C1 formatted to General or Number.
Click to expand...
 
Back
Top