Support Board
Date/Time: Fri, 31 Oct 2025 05:56:12 +0000
Post From: Alert During Specific Time Period
| [2015-12-22 18:26:03] |
| Sawtooth - Posts: 4281 |
|
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"))) |