I need to find a formula that can tell me if certain conditions are met in multiple columns.

I have Column A “Day of Week” and Column B “24 Hr Clock”

In column C I would like to show a TRUE value if the conditions met are Monday through Friday between 9 and 19

If the day of the week is Saturday or sunday, or if 24 hr clock is between 19 and 8, column C should show a FALSE Value

I tried this formula and the values I received back were TRUE only for the first condition (eg Monday between 9 and 19)

=AND(A7=”Monday”, B7>9, B7<19)=OR(A7=”Tuesday”, B7>9, B7<19)=OR(A7=”Wednesay”, B7>9, B7<19)=OR(A7=”Thursday”, B7>9, B7<19)=OR(A7=”Friday”, B7>9, B7<19)