Place LAY 30 seconds before start

[guy333]

This must be really simple.

All I want to do is place a lay bet at a specific time before the start.

In Excel I have tried =IF(F4<30,"LAY","")

I have tried =IF(F4"<30","LAY","")

I have tried =IF(F4"<30.0","LAY","")

For all of these the lay is placed straightaway, without reference to the time.

If I try =IF(F4=30,"LAY","") then no lay is placed.

Any suggestions?

Thanks

[foxwood]

=IF('Bet Angel'!F4<TIME(0,0,30),"LAY","")

The countdown is a time field where 30 seconds has a value of 0.000347 which is less than integer 30 so always places bet.

[guy333]

Thanks, you put me on the right track.

[guy333]

I thought I had got this to work this morning but now if I include the "lay" it just literally prints lay but does nothing else and if I don't include the " around the word lay then nothing happens and it it comes up with #NAME?.

This is so frustrating.

Also how do you fix the order for a horse race in excel?

I assumed an automation rule would do it but it doesn't seem to have any effect.

[guy333]

Hopefully sorted now.

My stencil was named "copy of bet angel" so once I deleted "copy of" it worked again.

Hopefully that will also solve the fixing of the horse order as well.