For loop calculation with functions to add numbers in a table

time taken Capture.JPG

This can be achieved by for loop/macros/VBA etc but if we can do it by functions, that would be great!

Every hole has a time attached/allotted to it. At any given time we need to calculate the stipulated time allotted to the players until that particular hole.
I have attached a screen shot to make it easier to comprehend.

I need to add up the time or the pick out the total time and substract what's not needed.
Let's say, I am on hole 7, the player started on 1 going to 9. I need 105 mts
if the player started on 5, going to 13, on hole 10, answer wd be 90 mts (150-60)...and so on. The problem gets a wee bit complicated when we turn 18 and start again on 1.

Presently, I am vlooking up the above numbers and substracting and its complicated, with numbers of cases and ending up using nested IF statements and its getting tedious!!
I have start hole, end hole, status hole. I need to calculate time for 'status hole'.

Any help?!

---------------------------------------------------------------------------------------------------
Comments added from my previous post to clear some nuances of golf.

I am starting at hole no 1. If I play 9 holes, I end at hole number 9. If I play 18-hole round, I end at hole 18.
(so we are counting the hole that we start on..therefore 1+9=9...!)

If I play a 9-hole scramble, I can start only on the hole that I am assigned. Therefore I could start at hole 5, I end at hole 13. If I start at hole 13, I end at hole 3.
If I play a 18-hole scramble,I could start at hole 5, I end at hole 4. If I start at hole 13, I end at hole 12.

For those that are not golf-savvy
Front nine- 1 through 9 (holes)
Back nine - 10 through 18 (9 holes)
..and only in a tournament, start any hole and end after playing 9 or 18, hole 1 following hole 18.