Hi,
In a spare cell, for example AA1 use the following Excel formula to display number of seconds until the Official Off time:-
- 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,"-",""))))
Then in your trigger, you can use an IF statement to check the seconds in AA1, for example:-
- Code: Select all
=IF(AA1<=1,"LAY","")
And let's say, you wanted to check multiple criteria, for example you also want to check that the lay price is less than 2.0, then you can use the AND function in your IF statement:-
- Code: Select all
=IF(AND(AA1<=1,H5<2),"LAY","")
Regards,
Mark