sla

  1. H

    Excel - Comparing specific date and times

    I'm trying to create a tracker that contains a column to check if we've met SLA. Column A - Date Received Column B - Time Received Column C - Date and Time Combined (A2+B2) Column D - Date Resolved Column E - Time Resolved Column F - Date and Time Resolved (D2+E2) Essentially, what I need to...
  2. T

    Help to calculate 12 hour SLA, 7 days a week based over 10 hour opertaing day

    Hello, I would be most grateful for help, I am trying to calculate SLA for call attendance based on 7 days per week with operating hours of 08:00 - 18:00, SLA of 12 hours. The only solution I can find uses workday which then does not return correct weekend calculations, I feel so silly but can...
  3. B

    Matrix Table - Add Column to the end of the Matrix (not on every column)

    Hey Guys, Looking for some help here - I havent been able to find a solution anywhere. I have a matrix table that provides a view of aging inventory. For each client they have a number of days to work the ticket before it is outside of SLA. I want to add a column that shows when those...
  4. G

    Sum with Index and Match or Vlookup?

    Hi guys, If you guys could help me it would be great. so basically I have a spreadsheet of Daily SLA that needs # of Cases and Cases Processed added. I couldnt figure out and I have searched google and youtube. Column A just has the name of the Task (i.e. Logging voicemail SLA#1) because...
  5. wsnyder

    Sort Pivot Table On Two Columns

    Hi all, Using Excel Office 365. How can I sort a Pivot Table on 2 Columns? I have a count of work tasks and an SLA from 0% - 100% I want to sort the Pivot so the Top 20 opportunities are at the top where a low SLA count with a high work task count should be near the top. If the SLA is high...
  6. G

    Need to calculate the SLA time

    Hi Team, I have data where i need to calculate the dates for the tickets completed within SLA between 2 dates, i.e. created date and closed date. the table is below, please someone help. <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody> ID Date/Time Created Due Date...
  7. J

    SLA Breach Calculator different SLA Times

    Good afternoon, I have to find a way of working out if incidents have breached SLA which I am having trouble seeing as some priority incidents are 24*7*365 such as Priority1 and Priority 2 yet Priority 3 & 4 the SLA clock runs from 7am-7pm Mon-Friday. I have created 3 tables so far, 1 with the...
  8. S

    Calculate and populate duration (days) into cell 3 from cell 1 & 2 that contains specific words

    Hi All, Apologies if i'm not posting in the correct section. I tried to find the most appropriate discussion thread. This is quite a complicated one (well for me at least) so i'll really be impressed if this can be solved. What i'm trying to do is calculate and populate the SLA Deadline cell...
  9. G

    reporting in excel

    Hi, i need to have a report, i already done a little, but still need a help. <tbody> START DATE Get the Start Date based on the Task ID WORK DAYS Get age of item in business days upon completion SLA If item is completed within SLA, put 1, otherwise put 0 (refer to the Function SLA table...
  10. R

    Calculating Next Working Day

    I have several different categories of work in a spreadsheet, where not all categories have the same SLA for completion. I've been using this formula for the past few months, and there hasn't been an issue, until last Friday. Essentially, a record came in with a start date of 11/22/18. That...
  11. I

    SLA Calculator - Difference between 2 dates, incorporating work hours

    Hi all. I'm attempting to work out the difference between two date and times. Scenario: I work in IT and 'm an SLA manager. I've been tasked with finding SLA compliance between incidents raised and initial incident response. Normally this would be fairly simple, however the SLA 'clock' only...
  12. B

    Formula for counting SLA

    Hi all, Need some help with SLA generation as I've expanded all my resources to find the answers and this is why this is my first post. I'll try to be as thorough as possible. The SLA computation in my customer's account has a 3 days SLA to complete tickets. Example: - Supported hours - 7am...
  13. I

    Formula Help

    Afternoon I hope some kind some may be able to help me. I have a worksheet where I would like to be able to calculate an anecdotal 'Result' against some date based fields. I.e. 'Response SLA' and 'Actual Response' - I would like to be able to compare these 2 dates and if the Actual SLA...
  14. V

    Hour formula

    <colgroup><col><col><col></colgroup><tbody> Shift Start Time (24 hour format Shift End Time (24 hour format) Process SLA (hours) 13:30 22:30 9 22:30 7:30 -15 </tbody> Formula Used in "Process SLA (hours)" =HOUR(B3)-HOUR(A3) -15 is the wrong answer. How will I get correct Hours (positive...
  15. C

    If with multiple criteria

    Hi, Am hoping that you guys can help. I am looking for a formula that shows if cell c8= Smart and cell j8 time is less than 4:00:00 them put Met SLA but if j8 is over 4:00:00 put Failed SLA and if C8= Customer raised ticket or Public raised ticket and j8 is uner 0:30:00 put Met SLA and if J8...
  16. S

    SLA compliance

    Hello. Could you please help me with formula for this one? How I can get % of how many are "Fit in SLA" ? If there are 4 in, 1 out? <colgroup><col></colgroup><tbody> Fit in SLA Fit in SLA Fit in SLA Fit in SLA Out if SLA </tbody> Thank you in advance.
  17. G

    How to forecast in Excel

    I have a forecasting question that I would like to solve in Excel. I need to be able forecast what the Inventory Completed should be in the future weeks to be at 90% SLA. Date: represents a business week in a calendar month Week: represents the first week in a calendar month (i.e., does not...
  18. E

    formula to determine if SLA was met

    Hi, I have raw data and need a formula to determine if SLA was met. I need it separated by same day, 1 day, 2 days , 3 days, 3+days from month to month. I need it to then give me the percentage (out of %100) per category to see where SLA was met or not met. I then need to show this in a stacked...
  19. Dnyan

    Calculate Turn Around Time and SLA

    Hi All, I want to calculate Turn Around time and SLA for making Tracker. So required VBA Code for this, so please help me. Below is the Details: <tbody> Shift Start Time 08:00 **** End time 17:00 </tbody> <tbody> Worktype TAT Start Time Turn Around Time Completed Time SLA ABC 2 Hours...
  20. P

    How to calculate incident SLA expiration

    Hi, I work on a helpdesk and need to calculate when an incident SLA is due to expire, relative to the hours of contracted service. We provide service 0700 to 2300hrs 7 days a week, and are required to fix a fault within 85 minutes, I can add 85 minutes to an incident start time when the start...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top