Results 1 to 6 of 6

Creating SLA spreadsheet

Threaded View

  1. #1
    Registered User
    Join Date
    01-06-2020
    Location
    Kentucky
    MS-Off Ver
    office 365
    Posts
    3

    Creating SLA spreadsheet

    Looking to create a spreadsheet based off strict SLA guidelines.

    Some basic conditions applies( holidays, Sundays and time of ticket work order creation)

    If ticket created is created Monday through Thursday before 9pm est., the SLA starts at the ticket create time has 24 hours to be onsite and 48 hours towards resolution
    If ticket is created Monday - Thursday after 9pm est., then the SLA starts the next day at 8am est. and has 24 hours to be onsite and 48 hours towards resolution
    If the ticket is created on Friday before 11pm est., the SLA starts at the ticket create time has 24 hours to be onsite and 48 hours towards resolution
    If the ticket is created on Friday after 11pm but before 8am Saturday, the SLA starts at 8am and has 24 hours to be onsite and 48 hours towards resolution
    If the ticket is created between 8am Saturday and 8am Monday, the SLA starts Monday at 8am has 24 hours to be onsite and 48 hours towards resolution

    National recognized holidays and Sundays do not count towards SLA

    Spreadsheet breakdown:
    Create date and time is located in V2
    Completed date and time is located in T2
    AE2 - Christmas Holiday

    I might not be 100% accurate on the holidays and sundays, but I have this as of right now.

    =NETWORKDAYS.INTL(V2,T2,11,$AE$2)-MOD(V2,1)


    End goal is to apply this to all workorders through the month to calculate SLA on a faster method than more of a current manual process.

    Any help would be appreciated!

    ***UPDATED SPREADSHEET***
    Attached Files Attached Files
    Last edited by kdun; 01-09-2020 at 03:27 PM. Reason: Updated Spreadshheet

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a new spreadsheet with select data from a previous spreadsheet
    By onkadonk in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-31-2015, 08:42 AM
  2. Creating a new spreadsheet with select data from a previous spreadsheet
    By onkadonk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2015, 09:01 AM
  3. Advice for Creating a Spreadsheet for Tablet & Other Spreadsheet Platforms
    By houseflipsheet in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 03-17-2014, 02:55 AM
  4. Creating a master spreadsheet based on various spreadsheet in Sharepoint
    By lmoura in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2013, 05:09 PM
  5. [SOLVED] I need some help creating a database for my spreadsheet
    By kirk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 05:27 PM
  6. Creating Consolidated Spreadsheet...
    By jhicker in forum Excel General
    Replies: 3
    Last Post: 02-20-2006, 07:05 PM
  7. Creating a form using a spreadsheet
    By Sam in forum Excel General
    Replies: 2
    Last Post: 05-15-2005, 04:06 PM

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