Subtract seconds from time
This tutorial shows how to subtract seconds from time using an Excel formula, with the MOD function
Hard coded formula
Cell reference formula
|
=MOD(B5-(60/86400),1)
=MOD(B5-(C5/86400),1)
|
GENERIC FORMULA
=MOD(time-(seconds/86400),1)
ARGUMENTS GENERIC FORMULA
=MOD(time-(seconds/86400),1)
ARGUMENTS EXPLANATION This formula uses the MOD function to subtract a number of seconds from a specific time.
Click on either the Hard Coded or Cell Reference button to view the formula that has a number of seconds that are to be subtracted from a specific time directly entered into the formula or referenced to a specific cell. |
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Add seconds to time | How to add seconds to time | |
| Add minutes to time | How to add minutes to time | |
| Subtract minutes from time | How to subtract minutes from time | |
| Add hours to time | How to add hours to time | |
| Subtract hours from time | How to subtract hours from time |
RELATED FUNCTIONS
| Related Functions | Description | Related Functions and Description |
|---|---|---|
| MOD Function | The Excel MOD function returns the remainder after dividing a number by the divisor |