Spreadsheet: 81203d1281455711-converting-irregular-scores-into-then-grouping-them-738846_crashedinexcel
Sheet: eg for excel forum

Measure A |  |  |  |  | Measure B |  |  |  | Average
Time | Absolute score | Relative Score | 00:01:11 |  | Time | Absolute score | Relative Score | 00:01:13 | % Trial | Absolute score | Relative Score
00:00:54 | 0.881 | 13 | 0 |  | 00:00:03 | 1.168 | 14 | 0 | 0 | 1.2364 | 16.6
00:00:56 | 2.076 | 31 | 0.028169014084507 |  | 00:00:04 | 1.138 | 14 | 0.0136986301369863 | 0.05 | 1.047 | 14.25
00:00:58 | 1.556 | 23 | 0.056338028169014 |  | 00:00:06 | 0.919 | 11 | 0.0410958904109589 | 0.1 | 0.87475 | 12.25
00:01:00 | 0.855 | 13 | 0.08450704225352113 |  | 00:00:08 | 0.856 | 10 | 0.0684931506849315 | 0.15 | 1.27775 | 17
00:01:02 | 0.924 | 14 | 0.1126760563380283 |  | 00:00:10 | 0.921 | 11 | 0.0958904109589041 | 0.2 | 1.321 | 17.33333333333333
00:01:04 | 0.908 | 14 | 0.1408450704225351 |  | 00:00:11 | 0.458 | 6 | 0.1095890410958904 | 0.25 | 1.469 | 19.75
00:01:06 | 1.094 | 16 | 0.1690140845070423 |  | 00:00:12 | 1.209 | 15 | 0.1232876712328767 | 0.3 | 1.964333333333333 | 25.66666666666667
00:01:08 | 1.187 | 18 | 0.1971830985915493 |  | 00:00:14 | 1.362 | 16 | 0.1506849315068493 | 0.35 | 1.94325 | 26.5
00:01:10 | 1.241 | 19 | 0.2253521126760563 |  | 00:00:16 | 1.468 | 18 | 0.1780821917808219 | 0.4 | 1.883666666666667 | 26.33333333333333
00:01:12 | 1.274 | 19 | 0.2535211267605634 |  | [NAME] | 1.491 | 18 | 0.2054794520547945 | 0.45 | 2.1568 | 28.8
00:01:15 | 1.695 | 25 | 0.2957746478873238 |  | 00:00:20 | 1.231 | 15 | 0.2328767123287671 | 0.4999999999999999 | 2.35325 | 31.5
00:01:17 | 1.699 | 26 | 0.3239436619718308 |  | 00:00:22 | 1.173 | 14 | 0.2602739726027397 | 0.5499999999999999 | 2.139333333333333 | 30.66666666666667
00:01:19 | 1.925 | 29 | 0.3521126760563379 |  | 00:00:23 | 1.734 | 21 | 0.2739726027397261 | 0.6 | 2.64 | 36
00:01:21 | 2.106 | 32 | 0.3802816901408451 |  | 00:00:25 | 2.133 | 26 | 0.3013698630136987 | 0.65 | 2.17425 | 29.5
00:01:23 | 1.831 | 28 | 0.408450704225352 |  | 00:00:28 | 2.061 | 25 | 0.3424657534246575 | 0.7000000000000001 | 2.2532 | 31.2
00:01:25 | 1.569 | 24 | 0.4366197183098592 |  | 00:00:30 | 1.906 | 23 | 0.3698630136986302 | 0.7500000000000001 | 2.396333333333333 | 31.33333333333333
00:01:27 | 1.662 | 25 | 0.4647887323943661 |  | 00:00:32 | 1.836 | 22 | 0.3972602739726027 | 0.8000000000000002 | 2.1958 | 30.4
[NAME] | 3.099 | 47 | 0.4788732394366198 |  | 00:00:34 | 2.251 | 27 | 0.4246575342465754 | 0.8500000000000002 | 2.412333333333333 | 31.33333333333333
00:01:31 | 1.589 | 24 | 0.52112676056338 |  | 00:00:36 | 1.527 | 18 | 0.452054794520548 | 0.9000000000000002 | 2.42375 | 34.75
00:01:32 | 2.682 | 40 | 0.5352112676056335 |  | [NAME] | 2.384 | 29 | 0.4657534246575343 | 0.9500000000000003 | 2.39 | 32.5
00:01:34 | 2.568 | 39 | 0.5633802816901406 |  | [NAME] | 2.112 | 25 | 0.4931506849315069
00:01:36 | 1.968 | 30 | 0.5915492957746478 |  | 00:00:41 | 2.787 | 34 | 0.5205479452054794
00:01:37 | 2.795 | 42 | 0.6056338028169013 |  | 00:00:43 | 2.355 | 28 | 0.5479452054794521
00:01:39 | 2.917 | 44 | 0.6338028169014084 |  | 00:00:45 | 1.882 | 23 | 0.5753424657534246
00:01:41 | 2.235 | 34 | 0.6619718309859155 |  | 00:00:47 | 2.256 | 27 | 0.6027397260273972
[NAME] | 1.903 | 29 | 0.6760563380281689 |  | 00:00:49 | 2.592 | 31 | 0.6301369863013698
00:01:44 | 2.004 | 30 | 0.704225352112676 |  | [NAME] | 2.138 | 26 | 0.6575342465753424
00:01:45 | 2.617 | 39 | 0.7183098591549295 |  | [NAME] | 2.421 | 29 | 0.684931506849315
00:01:47 | 2.2 | 33 | 0.7464788732394363 |  | 00:00:55 | 2.07 | 25 | 0.7123287671232876
00:01:49 | 2.235 | 34 | 0.7746478873239435 |  | 00:00:56 | 2.375 | 29 | 0.726027397260274
00:01:51 | 2.05 | 31 | 0.8028169014084506 |  | 00:00:59 | 2.54 | 31 | 0.7671232876712327
00:01:53 | 1.243 | 19 | 0.8309859154929577 |  | 00:01:01 | 2.414 | 29 | 0.7945205479452054
00:01:54 | 3.053 | 46 | 0.8450704225352109 |  | 00:01:02 | 2.41 | 29 | 0.8082191780821919
00:01:56 | 2.314 | 35 | 0.873239436619718 |  | 00:01:04 | 2.223 | 27 | 0.8356164383561644
00:01:58 | 2.336 | 35 | 0.9014084507042255 |  | 00:01:06 | 2.569 | 31 | 0.863013698630137
00:01:59 | 1.982 | 30 | 0.9154929577464787 |  | 00:01:08 | 2.354 | 28 | 0.8904109589041096
00:02:01 | 2.979 | 45 | 0.9436619718309858 |  | 00:01:11 | 2.398 | 29 | 0.9315068493150684
00:02:03 | 2.521 | 38 | 0.9718309859154926 |  | 00:01:13 | 2.259 | 27 | 0.9589041095890413
00:02:05 | 1.999 | 30 | 1 |  | 00:01:16 | 2.434 | 29 | 1