Support Board

Date/Time: Tue, 09 Dec 2025 04:53:08 +0000

Post From: Time formulas

[2017-05-10 13:55:05] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4296
It's much easier to use the TIMEVALUE function: Simple Alerts syntax: =AND(BARTIME >= TIMEVALUE("09:00:00"), BARTIME <= TIMEVALUE("14:00:00")) Spreadsheet syntax: =AND(FRACTIME(A3) >= TIMEVALUE("09:00:00"), FRACTIME(A3) <= TIMEVALUE("14:00:00"))