» 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 Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- A Mathematician Plays the Stock Market
- Microsoft Office XP Introductory Concepts and Techniques
- Writing Excel Macros with VBA, 2nd Edition
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
No comments have been submitted.
