Login Page - Create Account

Support Board


Date/Time: Wed, 25 May 2022 03:24:44 +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