Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

calculation of overnight working times

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!

1 Solution

Accepted Solutions
swuehl
Not applicable

calculation of overnight working times

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))

2 Replies
swuehl
Not applicable

calculation of overnight working times

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))

Not applicable

calculation of overnight working times

Danke!