Convert Seconds to h:mm:ss

Excel Formulas › Date & Time

All versionsTEXT

A duration logged as 3725 seconds is hard to read. Divide by 86,400 to turn it into Excel’s time units, then format — 3725 becomes a tidy 1:02:05.

Quick formula: for a number of seconds in A2:
=TEXT(A2/86400, "[h]:mm:ss")
86,400 is the seconds in a day. Dividing converts to Excel’s day-fraction; [h]:mm:ss formats it, with brackets so hours pass 24 if needed.

Functions used (tap for the full reference guide):

TEXTINT

The example

Raw seconds turned into readable durations.

AB
1Secondsh:mm:ss
237251:02:05
3900:01:30
410000027:46:40

The formula

Seconds as a readable duration:

=TEXT(A2/86400, "[h]:mm:ss") // 3725 → 1:02:05

How it works

Convert to Excel’s time scale, then format:

  1. Excel measures time as a fraction of a day. There are 86400 seconds in a day, so A2/86400 converts seconds to that scale.
  2. TEXT(…, "[h]:mm:ss") formats the fraction as hours, minutes, and seconds.
  3. The square brackets around h let the hours exceed 24 — so 100,000 seconds shows as 27:46:40, not 3:46:40.
  4. Prefer a real value over text? Put =A2/86400 in a cell and apply the [h]:mm:ss number format directly — then it’s still a number you can add.

Going the other way? To turn a time back into seconds, multiply by 86,400: =A2*86400. The same logic with 1440 converts to/from minutes.

Try it: interactive demo

Live demo

Enter a number of seconds.

Duration:

Variations

As a real time value

Keep it numeric for math:

=A2/86400 // then format [h]:mm:ss

Minutes:seconds only

For short durations:

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

Time back to seconds

Reverse the conversion:

=A2 * 86400

Pitfalls & errors

Use the brackets for long durations. Plain h:mm:ss wraps at 24 hours; [h]:mm:ss shows the full elapsed time.

TEXT returns text. The result is a string you can’t do math on. If you need to keep adding durations, store =A2/86400 as a value and format the cell instead.

Fractional seconds need .00 in the format (e.g. [h]:mm:ss.00) or they’re hidden.

Practice workbook

📊
Download the free Convert Seconds to h:mm:ss practice workbook
A seconds-to-duration converter with the value-vs-text, m:ss, and reverse variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I convert seconds to h:mm:ss in Excel?
Divide by 86,400 and format: =TEXT(A2/86400, "[h]:mm:ss"). The division converts seconds to Excel time units and the brackets let hours exceed 24.
Why use [h] instead of h in the format?
Square brackets stop the hours from resetting at 24, so 100,000 seconds shows as 27:46:40 rather than wrapping.
How do I keep the result as a number I can add?
Put =A2/86400 in the cell and apply the [h]:mm:ss number format. TEXT returns a string you can't do math on.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Sum time past 24h · Time difference · Round time to interval

Function references: TEXT · INT