The formula is in the yellow cells in the data validation already, but here it is if this helps, in cell A3 is =(A3>=B2)+(B2-A3>20/24). I want them to be able to select a time from the list, but it cannot overlap previous time.