negative time values problems

[josthkko]

I have set up a bot that stops betting 20 seconds before the off. But when the timer goes to negative values it starts betting again. Why does that happen? How could i avoid it?
Any help appreciated!

[GaryRussell]

Without seeing what logic you are using to determine when it is 20 seconds before the off it's impossible to say why it continues betting. I can only tell you how I do it. I use the following formula to calculate seconds before the off.

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,"-",""))))

This formula will calculate a negative value after the scheduled off so you just need to check it is >=20

[Captain Sensible]

You could also just include an AND statement within your code to check for a negative time and use that to avoid betting

=IF(AND(LEFT(D2)<>"-",any other criteria),"bet","no bet")

[josthkko]

Yes, thank you both! Exactly what i was looking for

[crocogotter]

You could also just include an AND statement within your code to check for a negative time and use that to avoid betting

=IF(AND(LEFT(D2)<>"-",any other criteria),"bet","no bet")

All hail the search function. Exactly what I wanted, as for some reason I was also having a problem once the scheduled start time had passed but the event wasn't yet in play; for some reason a negative number wasn't deemed to be <0????

New to Gruss, and to Excel, so not ventured into macros and stuff just yet but managing with logical arguments in the main, having fun and learning lots.

Thanks Captain.