Support Board
Date/Time: Sun, 22 Dec 2024 17:30:46 +0000
Post From: Exit at certain time
| [2015-02-11 21:55:01] |
| Sawtooth - Posts: 4141 |
|
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
|