2 Replies Latest reply: Mar 29, 2012 10:05 AM by ASchempp
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!