calculation of overnight working times

[#1]

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

[swuehl · Accepted solution]

Not sure if I understood what you want to tell with the excel style expression, but maybe like

=interval('09:00'-'22:00'+if('22:00'>'09:00',1,0))

or

=interval(EndTime-StartTime+if(StartTime>EndTime,1,0))

[#3]

Danke!