21 Replies Latest reply: Jun 12, 2015 4:18 PM by Thomas Burnson RSS

    Calculating how long a request takes

    Thomas Burnson

      Hi,

       

      I'd like to ask how I can calculate the total time between two dates and then display this data in a visual representation?

       

      For instance:

      Open Dates:

      5/24/2014

      6/11/2014

      6/22/2014

      6/22/2014

      9/12/2014

       

      Close Dates:(respectively)

      5/24/2014

      6/12/2014

      6/23/2014

      6/22/2014

      11/11/1014

       

      Then what I am looking for is a new table that I would like to display in hours

      Hours Open:

      2

      12

      14

      1

      1443

       

      I know how to take the data and display it, but I am more so aiming to display statistics on how long a ticket was open with support or a secondary approver.

       

      Any thoughts?

      Thanks Kindly