Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 25 Apr 2024 17:43:53 +0000
Post From: Automated Trading
| [2019-01-11 15:59:37] |
| Sawtooth - Posts: 3976 |
|
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) |