1 Reply Latest reply on Apr 8, 2016 2:30 AM by Łukasz Majewski

    Help with Elapsed Time in DDD:HH:MM format

    Andy Eunada

      Hello All,

       

      I am trying to calculate the elapsed time a ticket was opened for.

       

      Example:

      Start Time

      1/2/2015  3:43:38 PM

       

      End Time

      11/2/2015  5:56:34 PM

       

      Elapsed Time Calculation

      [End Time] - [Start Time] = 304.09

       

      I want to format the 304.09 to DDD:HH:SS format, but I'm unable to do so.

      Under Default Properties > Number Format > Custom; I formatted as DDD:HH:SS, but it's coming out as 30:2:12. The days portion is incorrect.

      It should be 304:2:12 for 304 Days 2 Hours 12 Minutes.

       

      Any suggestions?

       

       

      Thanks!