Support Board

Date/Time: Sat, 27 Apr 2024 02:10:26 +0000

Post From: Trading Hours Question

[2013-06-09 13:36:47] Link To Thread - Link To Post [Go To First Post]
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