Hello there,
I have a big problem.
I have this inputs
Column A: Time
Column B: Position Runner A in (%)
Column C: Position Runner B in (%)
Column D: Difference between A and B (%)
Column E: Active time when I should calculate the time.
The main problem is that I need to know how long does it take to Runner B to reach Runner A, while the active time (column E) is activated.
I have calculate the time but in an accumulated way (column I), BUT I need to know how long does it take each time, and not that accumulate the time of the first race.
I would like that once it reach Runner A, the calculate time will turn to 0 and then do it again when Runner A starts to run and starts to count form 0.
As you can see I have try several things in columns F and G and H but I’m stuck.
Bookmarks