2 Replies Latest reply: Mar 29, 2012 10:05 AM by ASchempp RSS

calculation of overnight working times

ASchempp

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 [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!