Support Board
Date/Time: Sat, 23 Nov 2024 03:34:05 +0000
Post From: Trading Hours Question
| [2013-06-09 13:36:47] |
| Richard Reyes - Posts: 98 |
|
I want to start trading Sunday (1) evening at 19:00:00 hours and stop trading on Fridat (6) at 15:00:00 hours. Would the following work? =OR(AND(WEEKDAY(J41)=1,J41-INT(J41)<TIMEVALUE("19:00:00")),AND(WEEKDAY(J41)=6,J41-INT(J41)>TIMEVALUE("15:00:00"))) If the above would work, how would I integrate it into my spreadsheet - cells H3 to H9 and J28? Many Thanks |