Convert seconds to hours, minutes, seconds in Excel

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:

  1. Right click the result cell
  2. Choose “Format Cells…”
  3. Select “Custom” in the “Category:” box
  4. Select “hh:mm:ss” in the “Type:” box

Done!

This post is also available in: Swedish

Leave a comment

Your email address will not be published. Required fields are marked *