» Adding a Number to a Formatted Time Value
Creating a formula that will return a time value which is
the sum of the time in A2 and the number of hours in B2.
When adding a time value and a number representing hours, we must first divide the number by 24, as shown in the following formula:
Ensure that the result cell is formatted [hh]:mm to correctly display a time.
Time_____Hours to Add___Result
|Screenshot // Adding a Number to a Formatted Time Value|