I having been trying, to no avail, to write a statement which takes into account the following variable

Weekday is not 1 or 7 - i.e. Weekends

That the time (broken into Hours and Minutes in seperate columns) is either:

Greater than 07:30 but less than 08:30

or

Greater than 18:00 but less than 18:30

Therefore if the weekday is 2-6 and either of the time statements are true I want Yes, if either the weekday is 1 or 7 or the time is outside of those times then No