Forum Discussion
Calculate Time Difference exclude non-operating hours and holidays.
Operation Hours for Monday to Saturday : 9:30am to 10pm Operation Hours for Sunday : 9:30am to 6pm TOT is the total time taken task took during operation hours only excluding Holidays Dates He...
See the attached workbook. You'll have to allow macros.
The holidays range and standard working hours range have been named Holidays and OperatingHours to avoid having to use their literal addresses in the VBA code.