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