Results 1 to 2 of 2

Thread: How to calculate handle time

  1. #1

    How to calculate handle time



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good day;

    i need some assistant, on how to calculate handle time. from report i have open time,close time and resolve time, the calculation should minus non operating Hour.

    Operating Hour: Monday Saturday: 8.30am 7.30pm
    Sunday 8.00am 8.30pm

    **Including Public Holiday.



    Thanks
    Attached Files Attached Files

  2. #2
    Excel 2010
    With holidays and 4 level SLA operating hours.
    With Defined Names and Macro.
    Easier version with Excel 2013 Pro Plus with Power Query available.
    http://www.mediafire.com/download/zl.../11_06_13.xlsm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •