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...
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...