This content has been marked as final.
Show 3 replies
-
1. Re: How to convert number of seconds to format mm:ss
Andrew Bickert Mar 8, 2018 2:02 PM (in response to Kelly C)1 of 1 people found this helpfulHi Kelly,
If you take your ASA value and divide it by 86400 it will convert it into the decimal time value. You can then click on format>pane>numbers, and type in "hh:mm:ss".
Andrew
-
2. Re: How to convert number of seconds to format mm:ss
Kelly C Mar 8, 2018 2:15 PM (in response to Andrew Bickert)Thanks so much Andrew! Did not know it was that simple.
-
3. Re: How to convert number of seconds to format mm:ss
Andrew Bickert Mar 8, 2018 2:17 PM (in response to Kelly C)No Problem, just an FYI, the reason for the 86400 is that is the amount of seconds in a day (24 hours x 60 minutes x 60 seconds).
Andrew