leighhobson89
New Member
- Joined
- Aug 25, 2016
- Messages
- 36
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)
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)
Dropbox
www.dropbox.com