Subtract minutes from time
This tutorial shows how to subtract minutes from time using an Excel formula, with the MOD function
Hard coded formula
Cell reference formula
|
=MOD(B5-(20/1440),1)
=MOD(B5-(C5/1440),1)
|
GENERIC FORMULA
=MOD(time-(minutes/1440),1)
ARGUMENTS GENERIC FORMULA
=MOD(time-(minutes/1440),1)
ARGUMENTS EXPLANATION This formula uses the MOD function to subtract a number of minutes from a specific time.
Click on either the Hard Coded or Cell Reference button to view the formula that has a number of minutes 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 minutes to time | How to add minutes to 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 |