Convert seconds to time
Tod,
Enter the number 86400 (the number of seconds in a day) into a blank cell.
Copy that cell, select your cells with the seconds data, and choose
Pastespecial divide. That will convert your seconds data into decimal days
data, which is what Excel wants. Then simply format the cells as times, and
you are done.
HTH,
Bernie
MS Excel MVP
"Tod" wrote in message
...
Here is an easy one for somebody.
I have a list of seconds in duration, like this:
124
1256587
2354
60521
235325
Why they chose to do it this way, (?). I want to format
this to show in the typical h:mm:ss format.
How?
tod
|