Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 10 May 2024 18:06:17 +0000

How to Post a Message for Support

Post From: Time formulas

[2017-05-10 13:55:05]
[Go To First Post]
Sawtooth - Posts: 3995
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"))