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

    calculation of overnight working times




      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!