Login Page - Create Account

Support Board


Date/Time: Thu, 11 Sep 2025 02:53:36 +0000



Post From: Exit at certain time

[2015-02-11 21:55:01]
Sawtooth - Posts: 4263
This will go TRUE at 17:00, and stay TRUE for 5 seconds:
=AND($J$41>TIMEVALUE("16:59:59"),$J$41<TIMEVALUE("17:00:05"))

This will go TRUE one hour after entry, and stay TRUE for 5 seconds:
=AND($J$41-$J$42>TIMEVALUE("00:59:59"),$J$41-$J$42<TIMEVALUE("01:00:05"))



Date Time Of Last Edit: 2015-02-11 23:04:59