Support Board

Date/Time: Wed, 27 Nov 2024 16:50:57 +0000

Post From: Spreadsheet study - How to flatten all positions just on Fridays

[2023-07-22 22:27:06] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4120
Try this: =OR(OR(FRACTIME(J41)<TIMEVALUE("14:00:00"),FRACTIME(J41)>TIMEVALUE("19:28:00")),AND(FRACTIME(J41)>TIMEVALUE("15:20:00"),FRACTIME(J41)<TIMEVALUE("17:00:00")),AND(FRACTIME(J41)>TIMEVALUE("17:30:00"),FRACTIME(J41)<TIMEVALUE("18:00:00"))) You had the right idea, but you were missing a couple of closing parentheses. - after the first FRACTIME(J41) - after the TIMEVALUE("17:00:00"))