» Adding a Number to a Formatted Time Value

Problem:

Creating a formula that will return a time value which is the sum of the time in cell A2 and the number of hours in cell B2.

Solution:

When adding a time value and a number representing hours, we must first divide the number by 24, as shown in the following formula:
=A2+B2/24
Ensure that the result cell is formatted [hh]:mm to correctly display a time.