I am trying to calculate the elapsed time a ticket was opened for.
1/2/2015 3:43:38 PM
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.