View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
GD[_2_] GD[_2_] is offline
external usenet poster
 
Posts: 3
Default Convert seconds to time

;o)))
hello !
slightly more concise like this :
=A1*"0:0:1"
@+
http://www.excelabo.net

Chip Pearson wrote:
Use a function like

=A1/60/60/24




"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