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