The running clock in triggered Betting

[cara]

I am having a problem with the running clock in an auto laying spreadsheet. In so far as I want to fire a bet at say 20seconds before the off. I convert the clock by using =D2-INT(D2)*24. Using set criteria, a horse is selected and the row highlighted. The problem is that immediately the running clock becomes a minus fig. I get a #value in all of the cells that have a connection to the time. The highlighted row of the selected horse also disappears. I need to know that selection because I fire off a BACK bet immediately the race becomes “INPLAY”. I also end up with “Invalid Price” in the stake col. ( I don’t know if this is a related problem or something else is going wrong)

Any help would be very much appreciated.

cara

[GeorgeUK]

Never tried changing the clock like that before.

I would work with something like this:
=IF(D2<=TIMEVALUE("00:00:20"),"BET","no bet")

So BET appears when within 20 secs of the start.

I'd double check that you are rounding to 2 decimal places for your stake.

[cara]

Thanx for prompt reply George, will try later today.

To coin a famous phrase, "I'll be Back"

cara