I've got a Google Sheets chart that displays the average pace of a day's rowing machine workouts (e.g. average the time to row 500m).
The Query I'm using to get the data is this: =QUERY(Data!A:Z, "select A, 15 / (avg(G) / 500) / (60*24) where D = 900 group by A order by A")
, where A
is the date, G
is the distance rowed, and D
is the time rowed (filtered to only include 15-minute sessions).
As you can see in the screenshot, I've formatted column B as a custom Duration that displays one decimal point after the seconds, but the chart rounds the paces down to the second before placing / labeling the points.
How can I stop Sheets from discarding the millisecond-component of the duration and make it differentiate between, for example, 0:02:05.8
and 0:02:05.6
in the height at which the points are placed?