Calculate Time Difference exclude non-operating hours and holidays.

Question

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

Help me Write a excel formula on Column F. The answer shown here is wrong

vinod2406 · Answer

Since you are having different operating hours , it is advised to mention all the dates from start date to end data in a column . You can map week name using text(A2,"DDD") and mapping hours or can use IF condition to get hours automatically

hansvogelaar · Answer

Jack0000&nbsp;
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.

Forum Discussion

Calculate Time Difference exclude non-operating hours and holidays.

Share

Resources