Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Tue, 22 Apr 2025 02:54:28 +0000

How to Post a Message for Support

Post From: Spreadsheet filled when condition not met. Alert Mgr

[2025-01-08 13:57:11]
[Go To First Post]
Sawtooth - Posts: 4209
You must use an absolute reference for any column J references:
=AND($J$8 = 0, AND(FRACTIME($J$41) >= TIMEVALUE("10:30:00"), FRACTIME($J$41) < TIMEVALUE("15:30:00")))