In Google Sheets, I want to have a column that compares times and writes for example "+0.02" if the time is slower and "-0.02" if it is faster

[leighhobson89]

Good Morning guys!!
I am making a training logger, and on each waypoint in my training circuit I record the split time with a stopwatch. Then I input the times in to my sheet. I am struggling with one column I wish to create, that compares the times of my current training session to the particular waypoint, against previous training sessions, and against the route benchmark.

I have explained everything in the following video to make it easy to know what I want to do. I know I need to look at the minimum value out of the second column and then every fourth column after that in the same row, and compare this with the cell for the split time in the current training exercise, but the honest truth is I just can't figure out how to look at the second column, and then every fourth column, and also how to integrate the time from the other sheet for the benchmark time. I would really appreciate some help on this. The video is here: (The video says every third column but i realised my mistake after making it, it is the second column of this row, and then every fourth one as they are added)

2021-02-23_10h42_40.mp4

Shared with Dropbox

www.dropbox.com

 

[leighhobson89]

By playing around and reading up, I was thinking that pulling out the split times from the 'nth' column to make them easily accessible as a range might be a good first step, but I still don't know if I am on the right track. Hopefully someone can help me as my head is exploding!!! Anyway I did this...