Support Board
Date/Time: Tue, 31 Mar 2026 09:05:05 +0000
Post From: Alert During Specific Time Period
| [2015-12-22 18:26:03] |
| Sawtooth - Posts: 4322 |
|
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"))) |