If I’m understanding correctly, this can be done with 2 tables, let’s call them ‘Athletes’ and ‘Scores’. You will need to create a Linked field and a Rollup field on your ‘Athletes’ table.
The end result for the Athletes table is something like this:
First you would create a linked field that is a Link to ‘Scores’, and allows for linking to multiple records. It sounds like you have this already.
Then create a Rollup field to display each athlete’s best time. For field, select the one that is linked to Scores, and Time (or whatever this field is called on Scores) as the field you’d like to rollup. Then for the aggregation formula, use:
On the formatting tab of the rollup field, you can select ‘Duration’ as the format, and choose the 2nd option - h:mm:ss for the duration format.
Then you would want to sort your view by ‘Best Time’ or whatever you’ve named this new Field
In the example I also created a ‘Date of Best Time’ field by duplicating the rollup field we just created, but selecting Date (which is created on the Scores table) instead of Time as the field to roll up.
If instead of duration you were counting reps of something (more is better), then you would change the formula in these Rollup fields to
MAX(values) and change the formatting from duration to number.
Also note that I didn’t build in the Workout A, Workout B formatting from your table, but instead just used the date of the workout and name of the athlete to differentiate Score records.
Hope that helps! Let me know if you run into problems.