Login Page - Create Account

Support Board


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



Post From: Disable Trading Time Formula

[2020-07-27 02:15:38]
Sawtooth - Posts: 4232
Try this in H28:

=OR(AND(FRACTIME(J41) > TIMEVALUE("00:00:00"), FRACTIME(J41) < TIMEVALUE("07:00:00"),J52=0), AND(FRACTIME(J41) > TIMEVALUE("09:00:00"), FRACTIME(J41) < TIMEVALUE("15:00:00"),OR(J52=0, AND(J52=1, FRACTIME(J43) > TIMEVALUE("00:00:00"), FRACTIME(J43) < TIMEVALUE("07:00:00")))))

Note: I didn't test this.

If this formula doesn't work for you, you can use these examples to create a formula on your own that does what you want.