Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Wed, 27 Nov 2024 16:44:12 +0000

How to Post a Message for Support

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

[2023-07-31 18:34:22]
[Go To First Post]
Sawtooth - Posts: 4120
Get rid of the leading left parenthesis:
=AND(WEEKDAY(J41)=6,FRACTIME(J41)>TIMEVALUE("23:20:00"))

Your J28 formula is missing two right parentheses, closing two FRACTIME(J41)s:
=OR(OR(FRACTIME(J41<TIMEVALUE("06:00:00"),FRACTIME(J41)>TIMEVALUE("23:30:00")),AND(FRACTIME(J41)>TIMEVALUE("08:30:00"),FRACTIME(J41)<TIMEVALUE("14:00:00")),AND(FRACTIME(J41)>TIMEVALUE("15:30:00"),FRACTIME(J41)<TIMEVALUE("16:00:00")),AND(FRACTIME(J41)>TIMEVALUE("17:00:00"),FRACTIME(J41)<TIMEVALUE("19:00:00")),AND(FRACTIME(J41)>TIMEVALUE("20:30:00"),FRACTIME(J41)<TIMEVALUE("21:10:00")))