Convert seconds into hours:minutes:seconds

[Jeff]

I have a set of values that are in seconds (ex. 35, 234, 564, 3, 1023). I
use the SUM function to add up all the seconds in the column. I would like
the sum to display the answer in the following format: hours: minutes :
seconds

ex.

35
234
564
3
1023

= 1859 seconds
= 0 hours : 30 minutes : 59 seconds

Thanks in advance


- Jeff

[WINNT 4 - SP 6, IE 6, Office 2000]

 

[Thomas]

Where A1 is the seconds to convert:
A1/24/60/60
format the cell as custom and enter:
hh " Hours":mm "Minutes":ss " Seconds"

 

[Random]

You could also use the following function formated for time as well:

=TIME(0,0,1859)

The [h]:mm:ss format works well also.

Be warned though, the function method only allows for 32767
seconds.

Where A1 is the seconds to convert:
A1/24/60/60
format the cell as custom and enter:
hh " Hours":mm "Minutes":ss " Seconds"

I have a set of values that are in seconds (ex. 35, 234, 564, 3, 1023). I
use the SUM function to add up all the seconds in the column. I would like
the sum to display the answer in the following format: hours: minutes :
seconds

ex.

35
234
564
3
1023

= 1859 seconds
= 0 hours : 30 minutes : 59 seconds

Thanks in advance

- Jeff

[WINNT 4 - SP 6, IE 6, Office 2000]