Login Page - Create Account

Support Board


Date/Time: Wed, 18 May 2022 13:18:32 +0000



Post From: SC code to define time period during which a spreadsheet alert i

[2013-05-18 17:33:24]
User12819 - Posts: 3
If someone else reads this post I would like them to know that using cell "J41" will not work. However,cell "A3" ( which contains the Serial Date-Time Value) DOES work! This is how I used it and it worked great: =AND(YourAlertConditions, A3-INT(A3)>TIMEVALUE("07:45:00"),A3-INT(A3)<TIMEVALUE("14:00:00")) Thanks for the help