Support Board
Date/Time: Thu, 10 Jul 2025 03:50:59 +0000
Post From: Alert During Specific Time Period
| [2015-12-22 18:26:03] |
| Sawtooth - Posts: 4236 |
|
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"))) |