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