Still trying

First, THANK YOU, Mark W. and Steven for your suggestions. I tried both but neither gave the results I need. So, I will expain my problem a little better. I need a formula that will check a cell for times, ie. 10:00 AM, 11:00 AM, in that format. I have tried using a cheat column putting my times in cells b4 and b5 and using this formula,"=if(c4=b4:b5, "name", "")" and it works but it will only give results for cell b4, I get nothing if I use the time in b5. I have also used the OR function but still no results. I need a formula like so, =if(c4=10:00 AM or 11:00 AM, "name", ""), but I also need the formula to be able to check for numerous times as well, ie. 10am, 11am, 2pm, 3pm,4pm, and 5pm.