Login Page - Create Account

Support Board


Date/Time: Sat, 10 May 2025 01:01:10 +0000



Post From: Exit at certain time

[2015-02-11 21:55:01]
Sawtooth - Posts: 4214
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