Reputation: 9875
How to add a column containing duration times, in format [hh]":"mm
, and sum them?
1:30
.[hh]":"mm
, so that the hours are counted as amount and not as datetime reference.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
)
Upvotes: 0
Views: 768
Reputation: 1055
Try this:
=ARRAYFORMULA(TEXT(SUM(IFERROR(TIMEVALUE(A3:A))), "[h]:mm"))
Upvotes: 1