Add seconds to time
This tutorial shows how to add seconds to time using Excel formulas, with the TIME function
|
=B5+60/86400
=B5+C5/86400
|
GENERIC FORMULA
=time+seconds/86400
ARGUMENTS GENERIC FORMULA
=time+seconds/86400
ARGUMENTS EXPLANATION This formula uses simple mathematical calculation, without use of any functions, to add a specific number of seconds to time. It takes the number of seconds and divides it by the number of seconds per day, which is 86400. It then adds this amount to the time.
Click on either the Hard Coded or Cell Reference button to view the formula that has the number of seconds to add to the time directly entered into the formula or referenced to a specific cell. |
|
=B5+TIME(0,0,60)
=B5+TIME(0,0,C5)
|
GENERIC FORMULA
=date+TIME(0,0,seconds)
ARGUMENTS GENERIC FORMULA
=date+TIME(0,0,seconds)
ARGUMENTS EXPLANATION This formula uses the TIME function to add a specific number of seconds to time. The TIME function returns the decimal number for the number of seconds that is selected. It then adds the number returned by the TIME function to the time. Using the TIME function you are limited to only use a maximum number of 32,767.
Click on either the Hard Coded or Cell Reference button to view the formula that has the number of seconds to add to the time directly entered into the formula or referenced to a specific cell. |
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Add hours to time | How to add hours to time | |
| Subtract hours from time | How to subtract hours from time | |
| Add minutes to time | How to add minutes to time | |
| Subtract minutes from time | How to subtract minutes from time |