I should have added that the hours each day are the same week to week. But, day to day, they are different. If it was the same hours each day, the filter would seem to be relatively simple.
Hi Charles, I think what you want to do can be accomplished using dateparts and an IF statement to generate a dimension with the values of open and closed. Here is a link to an example, however it only uses hours: Grouping hours