» Adding Time Values from Separate Hours and Minutes Columns

Problem:

Columns A & B contain numbers representing hours and minutes respectively.
We want to add the numbers from both columns to calculate a single cumulative time value.

Solution:
Use the SUM and TIME functions as shown in the following Array formula:
{=SUM(TIME(A2:A4,B2:B4,0))}
Screenshot // Adding Time Values from Separate Hours and Minutes Columns