Need formula in Calculating SLA

Status
Not open for further replies.

karthik444

New member
Joined
Jul 1, 2014
Messages
2
Reaction score
0
Points
0
Hello All,
Need formula for calculating SLA
My SLA requirements:
Priority 3: 24 Hrs. (1 Business day)
Priority 4: 48 Hrs. (2 Business days)
Priority 5: 120 Hrs. (5 Business Days)

Business days = Monday to Friday (24X5)

I need the SLA report whether SLA MET OR NOT MET... using the priorities in column D...
1SLA should be calculated using (Registered DT - Restored) (column K- column L)
It would be flexible if formula has option to add holidays if any...
 

Attachments

  • SLA.xlsx
    45.2 KB · Views: 12
Status
Not open for further replies.
Top