So to be clear, do you want to check if the current time is between those start and end times, or if the time in a field or perhaps the date time that the record was created was during the open times? I have given a formula below to give you what you asked for, but it may not be what you need. :)
Also, I am not sure what you want to do on weekends? Are you also open on Saturday and Sunday?
var timeofday Time = ToTimeOfDay(Now());
var number DayNumber = DayOfWeek(Today());
$DayNumber = 1 and $Time >=
[Monday start time] and and $Time <= [Monday end time]
or
$DayNumber = 2 and $Time >= [Tuesday start time] and and $Time <= [Tuesday end time]
or
$DayNumber = 3 and $Time >= [Wednesday start time] and and $Time <= [Wednesday end time]
or
$DayNumber = 4 and $Time >= [Thursday start time] and and $Time <= [Thursday end time]
or
$DayNumber = 5 and $Time >= [Friday start time] and and $Time <= [Friday end time]
or
$DayNumber = 6 and $Time >= [Saturday start time] and and $Time <= [Saturday end time]
or
$DayNumber = 0 and $Time >= [Sunday start time] and and $Time <= [Sunday end time]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
