How to Add Seconds to Time in Excel (Formula)

puneet-gogia-excel-champs

- Written by Puneet

To add seconds into a time value in Excel, you can use a simple and short formula where you need to refer to the original time from a cell and the second(s) value that you want to add after dividing it by the 86400 (which are totals seconds that we have in a day).

Below we have a time value in cell A1 (11:30:18 AM). And you need to add 34 seconds into this time.

time-value-in-cell

Excel Formula to Add Seconds to a Time Value

You can use the below steps:

  1. First, enter the equal operator in a cell and refer to the cell where you have the time.
  2. After that, enter the addition operator and then enter starting parentheses.
  3. Now, enter the value of seconds you want to add to the time.
  4. Next, enter the division operator and enter 86400.
  5. In the end, enter the closing parentheses and hit enter to get the result.
add-seconds-to-time-value
=A1+(34/86400)

Use the TIME Function to Add Seconds

In the same way, you can also use Excel’s TIME function to add seconds into a time. See the below example.

time-function-to-add-seconds
  1. In this formula, you need to refer to the cell where you have the time.
  2. After that, use the addition operator and enter the TIME function.
  3. In the time function, there are three arguments to define: hour, minute, and second. Use zero for hours and minutes; enter the seconds you want to add to the original time.
  4. In the end, hit enter to get the result.
=A1+TIME(0,0,34)

Get the Excel File

Last Updated: March 24, 2024