Time Code
 

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

Time Code
 

Hi Greg

=E4-C4+(E4<C4)

HTH. best wishes Harald

"Greg Brow" skrev i melding
...
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

Time Code
 

one mo

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

--
Regards,
Tom Ogilvy

"Harald Staff" wrote in message
...
Hi Greg

=E4-C4+(E4<C4)

HTH. best wishes Harald

"Greg Brow" skrev i melding
...
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