Add minutes to time

This tutorial shows how to add minutes to time using Excel formulas, with the TIME function

EXCEL FORMULA 1. Add minutes to time

EXCEL

Hard coded formula
Add minutes to time
Cell reference formula
Add minutes to time
=B5+(20/1440)
=B5+C5/1440
GENERIC FORMULA

=time+(minutes/1440)

ARGUMENTS
time: The time to add minutes to.
minutes: Number of minutes to add to the time.

GENERIC FORMULA

=time+(minutes/1440)

ARGUMENTS
time: The time to add minutes to.
minutes: Number of minutes to add to the time.

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.

EXCEL FORMULA 2. Add minute to time using TIME function

EXCEL

Hard coded formula
Add minutes to time
Cell reference formula
Add minutes to time
=B5+TIME(0,20,0)
=B5+TIME(0,C5,0)
GENERIC FORMULA

=date+TIME(0,minutes,0)

ARGUMENTS
time: The time to add minutes to.
minutes: Number of minutes to add to the time.

GENERIC FORMULA

=date+TIME(0,minutes,0)

ARGUMENTS
time: The time to add minutes to.
minutes: Number of minutes to add to the time.

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 TOPICS

Related Topic Description Related Topic and Description
How to add workdays to a date
How to add hours to time
How to subtract hours from time