I want to be able to sum time durations (e.g. "1:05:45", "5:40:13", "1:56:21" sum to "8:42:19") but I get an error:
*Error* Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC I see that currently "supported data types are string, number, boolean, date , datetime and timeofday" (Query Language Reference (Version 0.7) | Charts | Google Developers <https://developers.google.com/chart/interactive/docs/querylanguage>). However, it seems to me that Google Sheets should be able to convert the duration to its numeric value to send to the Google Charts Query and then convert the numeric values in the response from the Charts Query back to durations. I found that I can workaround this by maintaining an additional column using an ArrayFormula to convert the durations to numeric values myself and then I have to manually format the Query output to display those numbers as durations. It is a bit troublesome and difficult when I have multiple durations I want to work with. Can Google Sheets be updated to support durations in the QUERY function? Thanks. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
