topic Re: Calculate Business Hours Remove Weekends and Also Holidays in QlikView

Calculate Business Hours Remove Weekends and Also Holidays

QVUser1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

Please Find the below Screen Shot :

I need the business Hours Which should be Calculated from Morning 9.00 A.M to Evening 5.30 P.M

and also remove sat and Sunday along with Holidays.

Following Fields Are to be Derived: Total No. of Workings Hours, Total No of Non Working Hours

Thanks in Advance.

prashantsanchet — Wed, 29 Aug 2018 07:45:48 GMT

Hi ,

You can try using Networkays function .where you can pass start date,end date and holidays if any.

NetWorkDays(Start_Date,End_Date,Holidays date)

This function will return No of Working Days .You can multiply by 8.5 Hrs of daya.

This will return no of working hours.

Hope this will help

Regards,

Prashant