» Adding Text Values Representing Time

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 and simultaneously press .

Book Store:

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books

VIEW ALL BOOKS

Recommended Books:

• Microsoft Windows XP Step by Step (With CD-ROM)
• Accounting for Dummies
• Special Edition Using Microsoft Access 2002
• Microsoft Excel Version 2002 Step by Step
• Treason: Liberal Treachery from the Cold War to the War on Terrorism
• Marketing Plans

Email Tip

Print Tip

Add to My Tips

Rate This Tip

1 2 3 4 5

Rating: 1.50     Views: 25095

No comments have been submitted.

Name

Comment Title

Comments