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.

## Excel Formula to Add Seconds to a Time Value

You can use the below steps:

- First, enter the equal operator in a cell and refer to the cell where you have the time.
- After that, enter the addition operator and then enter starting parentheses.
- Now, enter the value of seconds you want to add to the time.
- Next, enter the division operator and enter 86400.
- In the end, enter the closing parentheses and hit enter to get the result.

`=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.

- In this formula, you need to refer to the cell where you have the time.
- After that, use the addition operator and enter the TIME function.
- 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.
- In the end, hit enter to get the result.

`=A1+TIME(0,0,34)`

## Download Sample File

## More Formulas

- Add Hours to Time in Excel
- Add Minutes to Time in Excel
- Calculate Time Difference Between Two Times in Excel
- Change Time Format in Excel
- Military Time (Get and Subtract) in Excel
- Separate Date and Time in Excel
- Convert an Excel Time Value into a Decimal Number (Hours)
- Convert Minutes into Hours and Minutes (HH:MM)
- Convert Time Value into Minutes (Excel Formula)
- Convert Time Value into Seconds
- Get Current Time (Excel Formula)
- Sum Time in Excel (Excel Formula)
- Convert Seconds to Hours and Minutes