Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Tue, 01 Jul 2025 03:18:34 +0000

How to Post a Message for Support

Post From: Disable Trading Hours with Spreadsheet

[2024-09-03 17:18:50]
[Go To First Post]
Sawtooth - Posts: 4231
You need 3 AND portions, each within the same OR, plus an overall AND for the J8.
None of your disable times span Midnight, so you don't need the OR portion within the OR.
And remember, the formula is using times to disable, not enable.

Try this:
=AND(J8=0,OR(AND(FRACTIME(J41)>TIMEVALUE("02:00:00"),FRACTIME(J41)<TIMEVALUE("04:15:00")),AND(FRACTIME(J41)>TIMEVALUE("08:00:00"),FRACTIME(J41)<TIMEVALUE("10:15:00")),AND(FRACTIME(J41)>TIMEVALUE("15:00:00"),FRACTIME(J41)<=TIMEVALUE("23:59:59"))))
Date Time Of Last Edit: 2024-09-03 17:37:04