Login Page - Create Account

Support Board


Date/Time: Sat, 13 Sep 2025 19:25:53 +0000



Post From: Automated Trading

[2019-01-11 15:59:37]
Sawtooth - Posts: 4263
The formula in post #16 does not return any errors for me. What is not working for you?

If you have many entry times, you could organize them in column H, then reference them in K3, like this:

H1:
=AND(FRACTIME(J41)>=TIMEVALUE("09:00:00"),FRACTIME(J41)<TIMEVALUE("09:00:06"))
H2:
=AND(FRACTIME(J41)>=TIMEVALUE("10:00:00"),FRACTIME(J41)<TIMEVALUE("10:00:06"))
H3:
=AND(FRACTIME(J41)>=TIMEVALUE("11:00:00"),FRACTIME(J41)<TIMEVALUE("11:00:06"))
K3:
=OR($H$1,$H$2,$H$3)