+ Reply to Thread
Results 1 to 2 of 2

Calculation of 'Breach Date and Time' that takes into account Business Hours

  1. #1
    Registered User
    Join Date
    02-21-2018
    Location
    Crewe, England
    MS-Off Ver
    2016
    Posts
    1

    Calculation of 'Breach Date and Time' that takes into account Business Hours

    Hi,

    This is my first thread.

    I am currently attempting to create an Excel Spread sheet to be used for the calculation of an SLA.

    At present I have most of it working to my needs but I am unable to get the Breach Date and Time to identify the initial non business hours if an ticket is logged out of hours for the specific SLA.

    I have attached the spread sheet that I have put together. In cell K7 I have a formula for WorkDay which is working from the opened time but not for the out of hours at the time of the ticket being logged.

    If anyone can offer some assistance and explanation it would be greatly appreciated.

    Regards
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,140

    Re: Calculation of 'Breach Date and Time' that takes into account Business Hours

    This is a UDF which means you have to macro-enable the workbook.

    http://www.utteraccess.com/wiki/Work...-_NetWorkHours
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Future Date & Time within Business (Office Hours) only
    By analystbank in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-22-2017, 05:02 AM
  2. Replies: 8
    Last Post: 01-31-2016, 10:14 AM
  3. Replies: 10
    Last Post: 07-10-2015, 10:40 AM
  4. Replies: 2
    Last Post: 11-12-2014, 11:56 AM
  5. time/date tracking only during business hours
    By mmarff in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-04-2009, 06:58 PM
  6. "Business Hours" Time Calculation
    By Skoal in forum Excel General
    Replies: 3
    Last Post: 10-24-2007, 12:21 PM
  7. How do I add 12 business hours to the current date/time?
    By adrianbarnes.com@gmail.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-09-2006, 07:50 PM

Tags for this Thread

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