+ Reply to Thread
Results 1 to 2 of 2

Help: Required for SLA calculating formula

  1. #1
    Registered User
    Join Date
    04-06-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    9

    Help: Required for SLA calculating formula

    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)

    I need the SLA report whether SLA MET OR SLA NOT MET... using the priorities in column D...

    1. SLA should be calculated using COULMN P and Column O (Pending Closed DT - Registered DT)
    2. IF the SLA is not in the above step then SLA should be calculated from COULMN Q and Column O ( Restored DT - Registered DT)
    3. The SLA should be calculated using the priorities in column D
    SLA report should also have any option to add holidays if any... and the work hours are 24 HRS Monday to Friday (24 x 5)
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Help: Required for SLA calculating formula

    Have you tried to search for SLA - some results are:
    http://www.excelforum.com/non-englis...werkdagen.html
    http://www.excelforum.com/excel-form...alculator.html
    http://www.excelforum.com/excel-form...-and-slas.html
    etc.
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Urgent Help required with Formulas for Calculating Commission
    By ALLYB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2013, 02:41 AM
  2. [SOLVED] Help Required: Stock lists - Calculating combinations of products
    By MaD2ko0l in forum Excel General
    Replies: 12
    Last Post: 05-12-2013, 10:47 AM
  3. [SOLVED] Help required on calculating formulas based on a drop down selection
    By cassyleighnz in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-06-2012, 02:37 AM
  4. Help required for calculating profit margins please.
    By Allgermanparts in forum Excel General
    Replies: 6
    Last Post: 07-02-2012, 07:22 AM
  5. Calculating a Required Date According to Two Criteria
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-23-2005, 11:49 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1