conversion seconds into minutes/hours
Put 86400 in a spare cell and copy it.
Select your range
Goto EditPasteSpecial 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)
"Willem" wrote in message
...
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
|