Tip Printed from ExcelTip.com

---

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 .