Converting irregular scores into % then grouping them

I've been trying to solve this myself for sometime and failed so I'm asking for some help please.

I have two measures which output an absolute score and relative score at irregular time points for the length of trial. Some trials take longer than others so I would like to align them by expressing the absolute and relatives scores as a percentage of the trial.
Relatively easy you'd think...
Measure A starts at time point (00:00:54 and ends at 00:02:05) whilst measure B starts at 00:00:03 and ends at 00:01:16)
Still not that hard...
Because of the irregular time points sometimes a row consitutes a 2 sec gap but sometimes it is 5 sec gap.
Getting tougher...
Once I have these figures expressed as a % of the trial I would then like to average them and group them into 5% of trial 'bins'
...And now I'm stuck!
If anyone could help me with this problem I've attached a sheet which I think might also help with what I'm looking for.
Thanks
Crash

Thanks for taking up the challenge donkeyOte.

What I want to do is calculate the average absolute and relative values of measures A and B express that as percentages of the trial.

I can see Step one is convert the times in column A into percentages of the trial ie the 00:54 of cell B3 is equivalent to the start or zero point of the trial and B4 is equivalent to 1.8% of the trial up to the value in B41 which is equivalent to 100 % of the trial.
Step two would be to do the same with Measure B. Step three would then be averaging the absolute and relative scores of measures A and B, and Step four would be batching the averages into 5% bins to be reported in column K. Ultimately I would end up with a score for each 5% of the trial in K3,K4,K5 and in L3,L4,L5 etc etc.

I'm struggling because the time scores in columns A and F don't start at the same time point or go up in the same increments. Although there are 39 rows of data each, Measure A is 71 seconds long, whilst Measure B is 73 seconds long, hence why I think they need converting to percentages of trial first. I then run into another brick wall when trying to find a convenient way of batching the averages into 5% bins for columns K and L.

Hope that helps with the puzzle.
Sorry for the delay in answering

Crash

Thanks, that formula is a great start!

I've attached a sheet with my long hand way of doing it thus far. Hopefully it demonstrates the expected values I'm trying to get at.

That looks like the business!

I'll test it out with some bigger data sets tomorrow, but I think you've cracked it.
Thank you

I've had a play and I'm getting there.

I need to incorporate 9 measures (measure a-i) of 4 variables (ab, rel, re, he) in the average. I only gave 2 of each in the eg because it was an eg, and I figured that that might be something I could sort myself! Turns out I was wrong.

When I try and edit the average formula to include these additional variables the { } around the formula disappears and therefore beyond row 3 the averages stop averaging. When I manually put {} back in there's a space that appears at the start of the formula that I can't seem to delete and the formula turns to text. Is there a way of stopping that happening?

Thanks

Found a few more measures so its now 10 not 8 measures that I need to average.
The original solution you provided is in the first worksheet, the solution required is on a second worksheet.
I've tried to copy across the solution you gave earlier, but as you can see I can't seem to make it work or include the extra measures required in the average. expected scores are given in the comments box.

Happy to hear what I'm doing wrong
Thanks
Crash

I've no idea how you did that but I am truely impressed!
Works a treat. Thanks.