5 Replies Latest reply: Sep 9, 2013 4:52 AM by Florian Pennetzdorfer RSS

    Calculate Time Interval Between Two Dates On Business Days For Business Hours Only

      Dear Community,

       

      I have two dates (close date and open date). I need to calculate the interval between these two and visualize it on a bar chart or maybe, even a table chart.

       

      REQUIREMENT: Calculate Time Interval Between Close Date and Open Date

       

      VISUALIZATION:

       

      Bar Chart showing average time taken to resolve a ticket (i.e., close_date - open_date) in %  against a cyclic dimension.

       

      CONSIDERATIONS:

       

      1. Calculated time interval should exclude weekends (Thu, Fri) in this case

      2. Calculated time interval should exclude non-business hours

       

      Valid business hours are 7 AM to 5 PM.

       

      Additionally, it would be great if I could also exclude the tea/lunch break duration from the business hours of a working day.

       

      I have found some posts on the community that almost solve this, but I could use some assistance to get this right, esp the valid business hours and weekends (Thu, Fri).

       

      Please find the Sample document attached.

       

      Thank you for your time.

       

      Regards,

       

      -Khaled.