Results 1 to 1 of 1

Thread: Need formula in Calculating SLA

  1. #1

    Need formula in Calculating SLA

    Register for a FREE account, and/
    or Log in to avoid these ads!

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts