1 2 Previous Next 16 Replies Latest reply on Nov 8, 2016 8:52 PM by Derek Arsenault Go to original post
      • 16. Re: How to Calculate Working Minutes- Excluding Weekends and Holidays
        Derek Arsenault

        This works very well!

        Thank you very much for sharing this.

         

        You'd think this would be a built in feature by now...we are version 10.

         

         

        What wasn't totally clear to me and took some time to figure out...the [FirstResponse] field you reference to...for me is actually the EndTime in my data set. I think someone else mentioned that it looked like your formulas were trying to capture response times, not so much ticket duration time, but it comes to the same thing, you just replace the [FirstResponse] field with the [EndTime] and it's all good!

         

        THANK YOU!!!

         

        Example output for my scenario where I want to exclude all non-business hours outside of weekdays 9AM-5PM:

        Outage ExampleStartTimeEndTimeExpected Hours (BH 9-5)Business Hours Calculated (hrs)
        2 weekdays11/20/2013 12:00:00 PM11/22/2013 12:00:00 PM1616
        Afternoon11/21/2013 12:00:00 PM11/21/2013 5:00:00 PM55
        over multiple weekends11/22/2013 3:00:00 PM12/02/2013 10:00:00 AM4343
        over weekend11/22/2013 3:00:00 PM11/25/2013 10:00:00 AM33
        Overnight weekday11/20/2013 12:00:00 PM11/21/2013 11:00:00 AM77
        same day11/20/2013 9:00:00 AM11/20/2013 4:00:00 PM77

         

        Now...to implement this into our workbook...the fun begins! :-D

        1 2 Previous Next