This content has been marked as final. Show 2 replies
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 [h]:mm
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!