Support Board
Date/Time: Sat, 30 Nov 2024 02:31:05 +0000
Post From: SC does not recognize the formulas
| [2022-12-27 20:12:26] |
| Hopeman - Posts: 166 |
|
I have a couple of questions, can you tell me if I can make the spreadsheet not work on certain days of the year? On the other hand, I am entering this formula so that it stops working at a certain time and returns SYNTAX. I copy it directly from the page. I have tried it several times in different ways and it returns the same error. AND(J8 = 0, OR(OR(FRACTIME(J41) < TIMEVALUE(“15:40:00"), FRACTIME(J41) > TIMEVALUE(“18:00:00”)), AND(FRACTIME(J41) > TIME VALUE("18:30:00"), FRACTO TIME(J41) < TIME VALUE("22:00:00")))) Thank you, You are very kind. Date Time Of Last Edit: 2022-12-27 20:17:50
|