Problem: You have a number of seconds in Excel that you would like to convert to hours:minutes:seconds.
Solution: Write the following formula in the cell where you want the result from the conversion:
=cell/(60*60*24)
Exchange “cell” above with a reference to the cell containing the seconds you want to convert, for exampel “A1″.
Format the conversion result cell:
- Right click the result cell
- Choose “Format Cells…”
- Select “Custom” in the “Category:” box
- Select “hh:mm:ss” in the “Type:” box
Done!
This post is also available in: Swedish
