Tip Printed from ExcelTip.com

---

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))}