Login Page - Create Account

Support Board


Date/Time: Fri, 04 Jul 2025 19:40:34 +0000



Post From: Disable Trading Time Formula

[2020-07-22 19:25:21]
Sawtooth - Posts: 4232
Try this in H28:
=OR(AND(FRACTIME(J41) > TIMEVALUE("00:00:00"), FRACTIME(J41) < TIMEVALUE("07:00:00"),J52=0), IF(AND(FRACTIME(J41) > TIMEVALUE("09:00:00"), FRACTIME(J41) < TIMEVALUE("15:00:00"),J52=0),AND(FRACTIME(J41) > TIMEVALUE("09:00:00"), FRACTIME(J41) < TIMEVALUE("15:00:00"),J52=0),AND(FRACTIME(J41) > TIMEVALUE("09:00:00"), FRACTIME(J41) < TIMEVALUE("15:00:00"),J52=1)))

Note: I didn't test this.