Hi everyone

Can someone please help me?

I was looking for ideal function to calculate SLA. There are post regarding SLA calculation only for Mon-Fr within operational hours.

My problem is how to calculate SLA when SLA is met within 2 hours and where it is met within 48hrs

Operational Hours:
Mon-Fr 8:00 - 20:00
Sat and Sunday 09:00 - 17:00



For example:

Case 1:

If drop down 1, in column A1, is selected.

SLA is met if action is taken within 2 hours.

Case 2:

If drop down 2, in column A2 is selected.

SLA is met if action is taken within 48 hours.

There may be more cases, i.e. with different drop down options but even if they have a different name, the "Case" type SLA times are the same. i.e. 3 drop down options are case 1 types, 2 are case 2 types.


Any help at all is appreciated.

Thank you