Convert seconds to time

Use a function like

=A1/60/60/24



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tod" <todtown@swbell.net> wrote in message
news:185e01c4f737$5e435730$a301280a@phx.gbl...
> 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
>

;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" <todtown@swbell.net> wrote in message
> news:185e01c4f737$5e435730$a301280a@phx.gbl...
>> 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