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.6 in the height at which the points are placed?