Login Page - Create Account

Support Board


Date/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")))