Converting seconds into a calculatable time format.
Posted by Cynthia on December 18, 2001 11:40 AM
Weekly I receive time data in seconds format. I need to be able to display the weekly data, and also show a running total of hours, minutes, and seconds in a pivot table. How can this be done?
Posted by Juan Pablo G. on December 18, 2001 12:08 PM
One second equals
=1/(24*60*60)
of a day. I hope that gets you started. If not, feel free to repost.
Juan Pablo G.
Posted by Mark W. on December 18, 2001 12:09 PM
If your seconds come to you as integer values you
1st should convert them to an internal time value
by dividing them by 86400 (e.g., 59/86400 =
0.00068287037037037, the interval time value for
59 seconds). Once your values are converted
format them as h:mm:ss. The SUM of these values
should be formated as [h]:mm:ss.
