3 Replies Latest reply on Dec 8, 2012 2:52 PM by philmodjunk

    Calculation for converting seconds to hours/minutes/seconds

    lbellino

      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