Net Working Time

[David_K]

Hi Everyone,

I am trying to calculate the net working time between 2 time stamps that must take into weekends, holidays.

Open Time: 14/04/2022 09:43:25

Close Time: 19/04/2022 10:05:48

Work day starts at 08:00

Work day ends at 18:00

the above period includes 2 holidays (15/04 & 18/04), as well as a weekend.

In Excel I get the networking time as 10:22:23 which is correct using the following formula

=(NETWORKDAYS(open,close,holidays)-1)*(ends-starts)
+IF(NETWORKDAYS(close,close),MEDIAN(MOD(close,1),ends,starts),UPPER)
-MEDIAN(NETWORKDAYS(open,open)*MOD(open,1),ends,starts)

Any support / guidance on how I can convert the above excel in to Qlik will be greatly appreciated.

Thanks in advance for your support

David