Seconds before start

[sion]

Does any one have the excel formula that i can insert into my sheet to place bet 30 secs before start, ive looked at the one in place_bets sheet but i cant change it to 30 secs.

[2020vision]

Hi

Put the following formula to calculate the seconds until the off in cell D2.
It shows a minus figure after the scheduled off.
Then simply use an IF statement in the trigger to fire at x or less amount of
seconds before the off that you require?

Code: Select all

=IF(LEFT(D2)<>"-",(HOUR(D2)*3600)+(MINUTE(D2)*60)+SECOND(D2),-((HOUR(SUBSTITUTE(D2,"-",""))*3600)+(MINUTE(SUBSTITUTE(D2,"-",""))*60)+SECOND(SUBSTITUTE(D2,"-",""))))

Hope it helps - Michael