Support Board

Date/Time: Wed, 27 Nov 2024 16:52:11 +0000

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

[2023-07-31 20:17:18] Link To Thread - Link To Post [Go To First Post]
Rui S - Posts: 190
Hi again, Sorry, I don't really understand what you mean when you say "Get rid of the leading left parenthesis" here: Get rid of the leading left parenthesis: =AND(WEEKDAY(J41)=6,FRACTIME(J41)>TIMEVALUE("23:20:00")) This is the formula nicely provided by you and it works very well. Regarding the bigger formula, the lack of that parenthesis you mentioned was somehow a typo of my part when I wrote my post. The formula is working and not returning any error. Here it is as I'm using it: =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"))) I realize now though that I wasn't clear with my question, so I'll try again but shorter: When I put that big formula you see above in J28, the existent formula in J29 =AND(WEEKDAY(J41)=6,FRACTIME(J41)>TIMEVALUE("23:20:00"))) stops working, meaning that the open positions don't get closed anymore on Fridays. I hope I have explained better this time. Thank you. Date Time Of Last Edit: 2023-07-31 20:18:37