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

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)

 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
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...

1614079038512.png
 
Upvote 0

Forum statistics

Threads
1,223,627
Messages
6,173,420
Members
452,514
Latest member
cjkelly15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top