Dear Experts
I've had a good search but can't find a solution. I'd like a formula to calculate service level completion times in conjunction with service availability. For example, service availability & levels could be
Mon-Fri, 08:00-18:00
Sat-Sun, 08:00-16:00
Bank hols, Unavailable
Service levels
5 working days
3 working days
2 working days
4 hours
2 hours
1 hour
30 mins
Ideally, I'd like the formula to reference the availability & service levels so that it can be adapted for other contracts.
Example spreadsheet attached. Can you please help?
Bookmarks