How do I change seconds to hours:minutes:seconds

Option 1: Convert using a formula

If your seconds are in column A (say A2 = 10441), use this formula:

=TEXT(A2/86400,"[h]:mm:ss")

• 86400 = number of seconds in a day (24 × 60 × 60)
• Dividing by 86400 converts seconds to Excel's time unit (fraction of a day).
• TEXT(...,"[h]:mm:ss") displays total hours, minutes, and seconds.

Option 2: Convert directly (without TEXT)

If you'd rather keep the values as time (not text), use:

=A2/86400

Then format the cell as:

Custom Format: [h]:mm:ss

1. Select the cells with the formula.
2. Press Ctrl + 1 → Number tab → Custom.
3. In the Type box, enter [h]:mm:ss.
4. Click OK.

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin