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. |