Time difference formula on 24hr clocks over midnight

[pigchicken]

Hi Guys,

Been stuck on this one for a while. Need to figure out some turnaround times for overtime (while filming we get overtime for however much we break an 11hr turnaround). So times are logged in 24 hr format, so I need to work out some time differences but having a huge amount of trouble doing so.

e.g. Out 19:00 In 06:00. I need this to generate the value 11:00 as its an 11hr difference but no idea how to make this work.

Thanks in advance.

Thanks,
P

 

[Weazel]

maybe something like...

=MOD("06:00"-"19:00",1)

formatted as h:mm

 

[pigchicken]

maybe something like...

=MOD("06:00"-"19:00",1)

formatted as h:mm

Great, I had tried the MOD formula, but for some reason in my mind never made the connection to just reverse and use the morning value first..... works great, thank you.

 

[Weazel]

you're welcome

 

[Rick Rothstein]

....but for some reason in my mind never made the connection to just reverse and use the morning value first...

Just to be clear about the formula Weazel posted, you are subtracting the start time from the finish time... it make no difference if the both times are before midnight, after midnight or straddling across midnight, the formula remains the same, subtract the start time from the finish time.