Help required in green up in excel.

[dreamcatcheromerta]

Hello Guys ,

I am trying to get program an excel sheet which makes a green up bet at user defined seconds ( 1to 60) after the start of the race.

I am having these problems and I would be glad if someone guides me in the right direction.

1).How can I calculate te starting time and place a bet say 10 seconds after the start of the race?

2)For calculating green up stake I am using the using the formula (original back bet odds)* stake( original back stake )/ lay odds.

Original back bet stake - entered by user.
Lay odds - entered by user.
Original backing odds- the problem is i have to get the backing odds at which the back bet was placed.But as the odds are refresed the value of the cell changes and I loose the value of the backing odds.

Please help me to solve this issue.

Thanks in advance.