AnsweredAssumed Answered

Calculation for converting seconds to hours/minutes/seconds

Question asked by lbellino on Dec 5, 2012
Latest reply on Dec 8, 2012 by philmodjunk

Title

Calculation for converting seconds to hours/minutes/seconds

Your post

     Hello.

     I currently have a calcuation that looks like this: = (EndTime - StartTime), which those are my two fields that I'm trying to determine how long it took to complete a request. This will populate in a third field called, "DurationTime". It's calculating fine, but it's in seconds only. How do I update this calculation to have it populate into hours, minutes, seconds? The image I've attached, shows the duration as 119 seconds, but I would like it to read: 1 min, 59 seconds, in this case. Thanks.

TimeCalculation.PNG

Outcomes