1 Answer 1


Try the below:

Assuming [Start Time] at 12:30, 1:15 or 1:30 PM

=AND(CHOOSE(WEEKDAY([Start Time]),FALSE,TRUE,FALSE,TRUE,FALSE,FALSE,FALSE),IF(OR(TEXT([Start Time],"hh:mm")="12:30",TEXT([Start Time],"hh:mm")="13:15",TEXT([Start Time],"hh:mm")="13:30"),TRUE,FALSE))

enter image description here

  • This worked perfectly, thank you so much! Do you have any ideas on how to get the 15 min. limit to work?
    – seaandtea
    May 6, 2021 at 15:01
  • That's means, [End Time] - [Start Time] =15 minutes, right? Yes, that can be done. I will try later today. May 6, 2021 at 15:24

Not the answer you're looking for? Browse other questions tagged or ask your own question.