30 Advanced Excel Tips for 2026

Excel Champs / Excel Formulas List / How to Convert Time Value into Seconds in Excel (Formula)
By Puneet Gogia (Microsoft MVP)

How to Convert Time Value into Seconds in Excel (Formula)

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

To convert a time into seconds, multiply it by 86400 — the number of seconds in a day: =A1*86400. Excel stores time as a fraction of a day, so 6:30:00 is 0.27083 and multiplying it scales it back to 23,400 seconds.

The result cell needs to be formatted as General or Number, otherwise it inherits the time format from the source and shows something odd rather than the number you want.

This works the same on a total: if you’ve summed several times, multiply that sum by 86400 as usual — but the summed cell must be formatted as [h]:mm:ss, since a total over 24 hours wraps around otherwise and you’d be converting the wrong value.

The alternative is =HOUR(A1)*3600+MINUTE(A1)*60+SECOND(A1), which reads more clearly but only works up to 24 hours, because HOUR resets after that. To go the other way, divide by 86400 and format the cell as time.

To convert a time in Excel into seconds, you need to multiply that value by 86400. This is the total number of seconds that we have in a single day, and Excel stores time as decimals (1 is equivalent to 24 hours). Now when you multiply time by the total number of seconds, it returns the number of seconds according to that time.

convert-time-values-into-seconds

Formula to Convert Time to Seconds

You can use the below steps:

  1. First, enter the equal to (=) operator.
  2. Next, refer to the cell where you have the time value.
  3. Now, enter the asterisk to multiply.
  4. After that, enter 86400.
  5. In the end, hit Enter to get the result.
formula-to-convert-time-to-seconds
=A1*86400

Once you enter the above formula in a cell, you need to have the cell format as “General“, so that you can have the number value in the cell.

apply-general-formatting-to-cell

Convert Total Time into Seconds

If you have a time value that is the total of multiple time values, you can still use the same formula. It also works when the total is more than 24 hours.

convert-total-time-into-seconds

In cell A3, we have the sum, and in cell A5, we have used the same formula to get the total seconds from the time value.

total-seconds-from-time-value

Use HOUR, MINUTE and SECOND Instead

You can also build the seconds from the parts of the time. For 13:20:15, it returns 48015, the same as =A1*86400:

=HOUR(A1)*3600+MINUTE(A1)*60+SECOND(A1)

But HOUR only returns 0 to 23, so this formula gives a wrong result for a total of more than 24 hours. For durations, stick with =A1*86400. The CONVERT function gives the same result as multiplying:

=CONVERT(A1,"day","sec")

If the result shows a tiny decimal like 48015.0000001, wrap it in ROUND(A1*86400,0), as floating-point math can leave a small difference.

Seconds Between Two Times

To get the seconds between a start time in A1 and an end time in B1, subtract and multiply by 86400. MOD makes it work when the end time is after midnight:

=MOD(B1-A1,1)*86400

Time with a Date or Stored as Text

If the cell also has a date, take the time part with MOD first. And if the time is stored as text, convert it with TIMEVALUE:

=MOD(A1,1)*86400
=TIMEVALUE(A1)*86400

Convert Seconds Back to Time

To turn a number of seconds into a time, divide it by 86400 and apply the [h]:mm:ss format to the cell (the square brackets let the hours go past 24).

=A1/86400

Frequently Asked Questions

Why is 86400 used to convert time into seconds?

A day has 24 hours, each hour has 60 minutes and each minute has 60 seconds, so a day has 24 x 60 x 60 = 86400 seconds. Excel stores a full day as 1.

Why does my result show as a time?

The result cell has a time format. Change it to General or Number to see the seconds.

Can I convert a time with milliseconds?

Yes. =A1*86400 keeps the fraction of a second as decimals. To show milliseconds in a time, use the custom format hh:mm:ss.000.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

Leave a Comment