Hi All, I have the following formula in a spread sheet. It works out the total SLA hours in the week from start date to end date.
=IF(F14>0,10/24*(NETWORKDAYS(E14,F14)-2)+TIME(18,0,0)-(E14-INT(E14))+(F14-INT(F14))-TIME(8,0,0),"Unresolved")
This works well if the times are weekdays between 8 and 6pm, and also deducts weekends.
Can anyone tell me how to subtract bank holidays if they are in the week? I have been dragged across the hot coals for missing this! ouch.
=IF(F14>0,10/24*(NETWORKDAYS(E14,F14)-2)+TIME(18,0,0)-(E14-INT(E14))+(F14-INT(F14))-TIME(8,0,0),"Unresolved")
This works well if the times are weekdays between 8 and 6pm, and also deducts weekends.
Can anyone tell me how to subtract bank holidays if they are in the week? I have been dragged across the hot coals for missing this! ouch.