Need formula adapting or alternative to include variable business hours at weekend and exclude holidays that can also occur at weekend e.g. New Years Day.
Formula should also allow for variable business hours each day during week but are same week to week and exclude holidays.
The formula below does NOT allow for variable business hours that do occur.
=((NETWORKDAYS(StartTime,EndTime,HolidayList)-1)*(BusHrsEnd BusHrsStart)+IF(NETWORKDAYS(EndTime,EndTime,HolidayList),MEDIAN(MOD(EndTime,1), BusHrsEnd, BusHrsStart), BusHrsEnd)-MEDIAN(NETWORKDAYS(StartTime,StartTime,HolidayList)*MOD(StartTime,1), BusHrsEnd, BusHrsStart))))
Bookmarks