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.