conversion seconds into minutes/hours

[Guest]

I have a telephone-report that gives me the number of seconds each
conversation has taken. I want to convert these seconds in a hh:mm:ss format.
Is there a function or a formula available in Excel that can do that?

Tnx

 

[Bob Phillips]

Put 86400 in a spare cell and copy it.

Select your range
Goto Edit>PasteSpecial and click Divide
OK

Format the cells as time, and claer the cell with 86400 in it

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Niek Otten]

=A1/24/60/60, Format as [hh]:mm:ss

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a telephone-report that gives me the number of seconds each
| conversation has taken. I want to convert these seconds in a hh:mm:ss format.
| Is there a function or a formula available in Excel that can do that?
|
| Tnx
|

 

[SteveW]

Seconds in A2, the following formula will convert
=A2/60/60/24

Format as [h]:mm:ss

Steve

 

[Guest]

seeing your solutions makes me small......
thanks a lot!

Seconds in A2, the following formula will convert
=A2/60/60/24

Format as [h]:mm:ss

Steve

I have a telephone-report that gives me the number of seconds each
conversation has taken. I want to convert these seconds in a hh:mm:ss
format.
Is there a function or a formula available in Excel that can do that?

Tnx