Add hours to time

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

EXCEL FORMULA 1. Add hours to time

EXCEL

Hard coded formula
Add hours to time
Cell reference formula
Add hours to time
=B5+1/24
=B5+C5/24
GENERIC FORMULA

=time+hours/24

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

GENERIC FORMULA

=time+hours/24

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

EXPLANATION

This formula uses simple mathematical calculation, without use of any functions, to add a specific number of hours to time. It takes the number of hours and divides it by the number of hours per day, which is 24. It then adds this amount to the time. This formula will account for decimal places, therefore taking into consideration minutes.

Click on either the Hard Coded or Cell Reference button to view the formula that has the number of hours to add to the time directly entered into the formula or referenced to a specific cell.

EXCEL FORMULA 2. Add hours to time using TIME function

EXCEL

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

=date+TIME(hours,0,0)

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

GENERIC FORMULA

=date+TIME(hours,0,0)

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

EXPLANATION

This formula uses the TIME function to add a specific number of hours to time. The TIME function returns the decimal number for the number of hours that is selected. It then adds the number returned by the TIME function to the time. With this formula you can only represent hours without any decimals (meaning no minutes).

Click on either the Hard Coded or Cell Reference button to view the formula that has the number of hours 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 subtract workdays from a date