Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 29 Apr 2024 02:14:34 +0000
[User Discussion] - Spreadsheet exit question
View Count: 1016
| [2014-04-09 20:13:18] |
| User14682 - Posts: 83 |
|
I have an exit located in j29 and would like to include a code to exit at a time value / =(J41-INT(J41))>TIMEVALUE("15:05:00") How do I incorporate time value into this code??? =IF(J8>0,OR(AND(AA4<AE4,AA5>AE5),AND(AA4<AG4,AA5>AG5)),IF(J8<0,OR(AND(AA4>AE4,AA5<AE5),AND(AA4>AG4,AA5<AG5)),FALSE)) Any help would be greatly appreciated Thanks |
| [2014-04-09 21:01:36] |
| Sawtooth - Posts: 3982 |
|
Try this: =OR(J41-INT(J41)>TIMEVALUE("15:05:00"),IF(J8>0,OR(AND(AA4<AE4,AA5>AE5),AND(AA4<AG4,AA5>AG5)),IF(J8<0,OR(AND(AA4>AE4,AA5<AE5),AND(AA4>AG4,AA5<AG5)),FALSE)))
|
To post a message in this thread, you need to log in with your Sierra Chart account: