» Adding Time Values from Separate Hours and Minutes Columns
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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))}
To apply Array formula:
Select the cell, press
Book Store:
Recommended Books:
- The Fall of Advertising and the Rise of PR
- Windows XP for Dummies
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Good to Great: Why Some Companies Make the Leap... and Others Don't
No comments have been submitted.
