Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Wed, 18 May 2022 12:43:18 +0000
Post From: SC code to define time period during which a spreadsheet alert i
| [2013-05-16 04:41:57] |
| tomgilb - Posts: 3270 |
|
Try something like this: =AND(YourAlertConditions,OR(J41-INT(J41)>TIMEVALUE("07:45:00"),J41-INT(J41)<TIMEVALUE("14:00:00"))) |