+ Reply to Thread
Results 1 to 2 of 2

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

  1. 02-21-2018, 12:00 PM #1
    stomoz
    stomoz is offline
    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
    Reply With QuoteRegister To Reply
  2. 02-21-2018, 06:14 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Start Date + Hours to produce end date & Time using Business Hours (AND include weekend)
    By starduck in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-31-2016, 10:14 AM
  3. Add number of hours to date and time field without counting in non business and Weekend hr
    By nchokshi in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-10-2015, 10:40 AM
  4. Time during business hours (week days) and time during Out of Hours (weekdays+weekends)
    By wintheranders in forum Excel General
    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 [email protected] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1