Time Code

[Greg Brow]

Could I please get some advise on a code for time, I have a shift that
starts at 19:00 and this person finishes at 07:00 the next day. How do I
write the code as the (07:00-19:00) e4-c4 does not calculate.

Thanks again

Greg

 

[Harald Staff]

Hi Greg

=E4-C4+(E4<C4)

HTH. best wishes Harald

 

[Tom Ogilvy]

one more:

=MOD(C4-E4,1)

Note that both Harald's and this one will work with any two times that are
within 24 hours of each other.