Categories
First Category

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: