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.



      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?