How can I stop Google Sheets charts from rounding down durations?

by Leon Overweel   Last Updated February 24, 2018 16:03 PM

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).

It looks like this: enter image description here

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?



Related Questions



how to importance with time spent date value

Updated April 15, 2018 15:03 PM



Next lowest value query

Updated November 08, 2018 17:03 PM