Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to calculate overnight working shifts and I was wondering how to epress this in the script:
Clock in Clock out Duration
22:00:00 07:00:00 09:00:00 = C9-B9+(B9>C9) and cell format
22:00:00 07:00:00 9.00 = C9-B9-(B9>C9))*24 and cell format is number with 2 digits
Thanks for your help!
Not sure if I understood what you want to tell with the excel style expression, but maybe like
=interval('09:00'-'22:00'+if('22:00'>'09:00',1,0))
or
=interval(EndTime-StartTime+if(StartTime>EndTime,1,0))
Not sure if I understood what you want to tell with the excel style expression, but maybe like
=interval('09:00'-'22:00'+if('22:00'>'09:00',1,0))
or
=interval(EndTime-StartTime+if(StartTime>EndTime,1,0))
Danke!