Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 31 Jan 2025 09:02:51 +0000

How to Post a Message for Support

Post From: Automated Trading

[2019-01-11 15:59:37]
[Go To First Post]
Sawtooth - Posts: 4164
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)