» Adding Time Values from Separate Hours and Minutes Columns
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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))}

Book Store:
Recommended Books:
- Financial Statement Analysis with S&P insert card
- Excel Charts
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Business Plans For Dummies®
- Word 2002: The Complete Reference
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.


