Why the sum of time-durations always returns zero, on a Google timesheet

Question

How to add a column containing duration times, in format [hh]":"mm, and sum them?

• I've added the time durations as hours:minutes in the Column A. I've inserted them as specified in the formatting; e.g. I've typed 1:30.
• I've formatted B2 and the whole Column A as [hh]":"mm, so that the hours are counted as amount and not as datetime reference.
• I've added the SUM(A3:A5) function in the B2 cell.

Here a sample:

(from this spreadsheet: https://docs.google.com/spreadsheets/d/1hvnivAmGX0ou-NudTK5o32UFSpxZTPLD265EcxC6MYs/edit?usp=sharing)

but, as you can see, the result of the SUM() function is always zero.

What's wrong? How to have a simple timesheet for total duration? (without having to generate them with a startCell - endCell)

Answer 1

Try this:

=ARRAYFORMULA(TEXT(SUM(IFERROR(TIMEVALUE(A3:A))), "[h]:mm"))