Kamafeather
Kamafeather

Reputation: 9875

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

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

Here a sample:

enter image description here (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)

Upvotes: 0

Views: 768

Answers (1)

Nabnub
Nabnub

Reputation: 1055

Try this:

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

enter image description here

Upvotes: 1

Related Questions