Need formula for calculating SLA

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: 223

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Try this

=IF(L2<>"",IF(NETWORKDAYS(K2,L2)-1>VLOOKUP(D2,{3,1;4,2;5,5},2,FALSE),"Not Met","Met"),"")
 
Top