» 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))}
To apply Array formula:
Select the cell, press
Book Store:
Recommended Books:
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Windows XP Pocket Reference
- Microsoft Windows XP Inside Out
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
How do I apply?
jeepers
The instruction say to press something, what am I suppose to be press in order to get this formula to work?
To apply Array formula:
Select the cell, press and simultaneously press .
To apply Array formula:
Select the cell, press and simultaneously press .