recording odds from a set time

[dflowe]

Hi, some time ago I came across and downloaded a spread sheet that could be set to record data from set times and at set duration......and i have lost it in an upgrade.......so.....can anyone suggest what it was called and where i might find it again please|????

[enery]

Mr Heath Robinson replying,

=IF(AO3="In Play",IF(AT1="",NOW(),AT1),"") That will time stamp the moment the race goes 'In Play' and is put in cell AT1(in this case), you could adapt that to =if(NOW()= "12:00:00",............

=IF(ISERR(NOW()-AT1),"-",NOW()-AT1) This goes in the next cell to the right(ie AU1) and will count the time the race is in play

In cell AV1 put your time you want to start betting or recording ie 00:00:10

Then =if(AV1=AU1,"your instructions","") bingo off you go!

This was all set up for in play betting but if you use your ingenuity you can time stamp each horse at 11.00 am or whenever with a bit of fiddling about

Hope this helps
Enery