» Adding Text Values Representing Time
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?
Use the SUM and TIMEVALUE functions as shown in the following Array formula:
To apply Array formula:
Select the cell, press and simultaneously press .