Solved: Office Hours - Page 2

Mitchell_Daly · 06-07-2019 11:01 AM

I have a form where i am trying to limit a response to a date/time question to weekdays during office hours. I have the solution to the weekday side of this from a previous question, which is listed below. I am curious about how I could put in the time of day restraint as well. Any thoughts?

NOT(IN(WEEKDAY([Barrel Drop Off Date/Time]), LIST(1, 7)))

Steve

Your expression should go in Valid if property for the Barrel Drop Off Date/Time column.

You’ll need to combine the weekday check and the hours check to get complete coverage.

AND(
  NOT(IN(WEEKDAY([Barrel Drop Off Date/Time]), LIST(1, 7))),
  (TIME([Barrel Drop Off Date/Time]) >= "09:00:00"),
  (TIME([Barrel Drop Off Date/Time]) < "15:00:00")
)

View solution in original post