» Adding Text Values Representing Time
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem:The times listed in column A are formatted as text.
When trying to add them using a simple SUM formula (=SUM(A2:A5)), a false result of 0 is returned.
How can we add text values correctly?
Solution:
Use the SUM and TIMEVALUE functions as shown in the following Array formula:
{=SUM(TIMEVALUE(A2:A5))}
To apply Array formula:
Select the cell, press
Book Store:
Recommended Books:
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Accounting the Easy Way
- Special Edition Using Microsoft Outlook 2002
- Personal Finance for Dummies
No comments have been submitted.
