Export only giving run times to nearest minute

Kind of a tangent, but I don't like the way Garmin exports CSV for Connect in general. Typically they use some non-normalized format which is ok for humans to look at, but bad if you want to do any kind of automated data processing. But if I just want to *look* at the data, it's already there in Connect. Usually CSV exports are used for further data processing.

For example, if you export laps/intervals from an activity, you get lap times which look like this:

4:30.5

4:45

4:25

This looks ok to a human, who can unambiguously interpret these numbers as "4 minutes and 30.5 seconds", "4 minutes and 45 seconds", and "4 minutes and 25 seconds".

But if you import that data to Excel or Google Sheets, you cannot do math on those numbers (like taking the average), because those apps will interpret those numbers as *4 minutes and 30.5 seconds", "4 hours and 45 minutes", and "4 hours and 25 minutes". (Well, actually, they're really being interpreted as timestamps, but the math would still mostly works as if it's durations in hours, minutes and seconds anyway.) I don't mention Numbers here, since Numbers doesn't seem to have the ability to do that kind of math on timestamps.

The right thing to do here would be something like this (which would work in Excel and Sheets):

4:30.5 (or 0:04:30.5)

0:04:45

0:04:25

(leading 0 added in "04" only for cosmetic purposes)

Ofc if it so happens that none of lap times has fractional seconds, it would work fine too:

4:30

4:45

4:25

Even though technically this is interpreted "4 hours 30 minutes" (or 4:30 AM), "4 h 45m", "4 h 25m", it doesn't matter because you can take the average of those durations/timestamps in Excel and get the right answer, regardless of whether Excel thinks the input/output are in hours and minutes or minutes and seconds.

I just don't think Garmin cares all that much tbh. That's why I don't use CSV exports for any kind of analysis. I prefer using runalyze.com (which syncs with Connect) to look at both individual activities and aggregate data, or using fitfilefileviewer.com to analyze the original data from activity FIT files.

DJGShef said:

scrolling down through the data to the end

But the infinite scroll implementation in the Connect website activity list sucks, as you can't jump to any point in the list instantly. The scrollbar / scrolling region only covers the handful of activities that are currently loaded / rendered. If you have a few years worth of activities, you will be scrolling for a long time.

(inb4 that's how infinite scroll works - yeah, for most sites/apps, but yet some sites/apps like strava, stryd and spotify figured out how to do this properly, so when they show users certain long lists, they have both infinite scrolling/lazy loading *and* they offer the ability to jump to any point in the list.)

DJGShef said:

the accurate time is under elapsed time or moving time

DJGShef said:

The 'Time' field is to the nearest minute

But ofc elapsed time and moving time aren't equivalent to the (total) time field....