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