Hi Team,
why can I not SUM time?
ex:
SUM(Select(table[hours],[_thisrow].[date]=[date]))
thks in advance
Here is a guide to doing exactly that: TOTALHOURS() | AppSheet Help Center
You cannot sum Time values, but you can sum Duration values. Convert your Time values to Duration values.
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |