Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 27 Apr 2024 07:59:53 +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"))) |