Login Page - Create Account

Support Board


Date/Time: Wed, 24 Apr 2024 23:06:33 +0000



Post From: Spreadsheet Time Values

[2014-01-30 10:46:33]
sbsierra - Posts: 71
hi,
you can use Cell J28 to disable autotrading

=OR(J41-INT(J41)<TIMEVALUE("09:25:00");J41-INT(J41)>TIMEVALUE("17:45:00");AND(J41-INT(J41)>TIMEVALUE("11:45:00");J41-INT(J41)<TIMEVALUE("14:00:00")))

This will enable from 9:25 till 17:45, but disable from 11:45 till 14:00

regards,

SB