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