Calculate Business Hours Remove Weekends and Also Holidays

[QVUser1]

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]

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