Login Page - Create Account

Support Board


Date/Time: Sat, 28 Dec 2024 07:23:18 +0000



Post From: spreadsheet study and time

[2015-12-23 02:43:23]
User175327 - Posts: 36
Hi, thanks for the response but that still does not seem to work. This is the current equation i am using:

=AND($J$41>=TIMEVALUE("08:00:00"),$J$41<=TIMEVALUE("08:10:00"),CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@4,ID3.SG1@3:ID3.SG1@4))

the ending part works just fine all on its own but when i couple it with the time constraint it doesnt return any signals. Any ideas?!