Timeline for Time tracking with Google Spreadsheets
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 12, 2017 at 15:08 | comment | added | Marcus Blättermann |
Yes I had the same problem. Forgot to mention that. The col with the duration needs to be set to Number, not Duration as a Number format. For some reasons the query can’t handle numbers in Duration format. If you still want to see it as Duration in the first table, you will need a second col, that just copies the value and is set tot Number. Its the same in my example tables, stops working if you set that row to Duration.
|
|
| Mar 12, 2017 at 15:05 | comment | added | Jernej Pangeršič | Thanks for the answer! One question though: I keep getting "Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC" on the Daily Overview A1 field | |
| Mar 12, 2017 at 12:01 | vote | accept | Jernej Pangeršič | ||
| Mar 11, 2017 at 19:34 | history | answered | Marcus Blättermann | CC BY-SA 3.0 |