'Google Sheets: Query data with HH:MM format
Which query should I use to calculate Total shift time and Total task time grouped by Shift?
Google Sheets query doesn't allow me to sum Col2 or Col3 because it's formatted into HH:MM (I can't change it to number because source data is HH:MM).
Solution 1:[1]
I feel you should change your source data so that the shift pattern is formatted to include both date and time. Then follow this procedure to do the correct arithmetic:
https://www.ablebits.com/office-addins-blog/2017/10/19/calculating-time-google-sheets/
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Mervyn |