Add hours to time
This tutorial shows how to add hours to time using Excel formulas, with the TIME function
Excel
Hard coded formula
Cell reference formula
=B5+1/24
=B5+C5/24
|
GENERIC FORMULA
=time+hours/24
ARGUMENTS GENERIC FORMULA
=time+hours/24
ARGUMENTS 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. |
Hard coded formula
Cell reference formula
=B5+TIME(1,0,0)
=B5+TIME(C5,0,0)
|
GENERIC FORMULA
=date+TIME(hours,0,0)
ARGUMENTS GENERIC FORMULA
=date+TIME(hours,0,0)
ARGUMENTS 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 |
---|---|---|
Add workdays to date | How to add workdays to a date | |
Subtract workdays from date | How to subtract workdays from a date |