» 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))}
Book Store:
Recommended Books:
- Mastering Excel 2000 (for beginner)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Marketing Plan: A Handbook with Marketing Plan
- Microsoft Windows XP Registry Guide
- Finance and Accounting for Nonfinancial Managers
No comments have been submitted.
