Support Board
Date/Time: Sun, 27 Sep 2026 16:41:15 +0000
Post From: Alert During Specific Time Period
| [2015-12-22 18:26:03] |
| Sawtooth - Posts: 4355 |
|
It's easier to use the TIMEVALUE function than arithmetic. And since you're crossing midnight, use OR instead of AND for the time window. Try this: =AND(ID1.SG1>150,OR(BARTIME >= TIMEVALUE("16:00:00"),BARTIME <= TIMEVALUE("02:59:59"))) |