Return a specific value 'Open' where days are between Monday

Home > database > Return a specific value 'Open' where days are between Monday - Friday and time is >=8:0

Return a specific value 'Open' where days are between Monday - Friday and time is >=8:0

Time：10-14

Return a specific value 'Open' where days are between Monday - Friday and time is >=8:00 & <19:00 all other days and times should return 'OOH'

Open = >=8:00 & <19:00 & Monday to Friday inclusive OOH = >=19:01 & <7:59 & Monday to Friday & anytime on Saturday or Sunday