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!