ContributionsMost RecentMost LikesSolutionsRe: Formulas HelpPerfect! that worked ------------------------------ Efren Torres ------------------------------ Re: Formulas HelpFirst off Thank you for your help! Second, we are open 24/7 and I want the check box to check if it is between the start and end time and not check the box outside of the start and end time. I also want it to take into account the day of the week because if the vendor is closed on the weekends I dont want the checkbox to be checked either. I was trying to use if statements but from your formula it looks like I wasn't even close. As far as the formula you did post I got an error(expecting Bool) on line 4 after the second AND ------------------------------ Efren Torres ------------------------------ Re: Formulas HelpYes I am making the mistake of trying to do like [Monday start time} - [Monday end time]. This gives me a duration. Thats not what I need at all so Im lost. I need the checkbox to change based on weather the current time is between the start and closed time and also be able to change day to day ------------------------------ Efren Torres ------------------------------ Formulas HelpHello, I am trying to get a checkbox to indicate if a vendor is open or closed. I have imputed the vendor times so my variables are like Monday start time, Monday end time ect. The only thing I have figured out is how to get duration. Any help would be great. Thank you ------------------------------ Efren Torres ------------------------------