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
