Hi all I want to look at some entries I have in C column and check for a time
(21:15) if it is there put "Closed"
What I have so far is
=IF(C5="21:15",C6="21:15","Closed")
This gives me the output for the cells mentioned but I want to go from C5 to C9..
When I try and add more cells to the function I get no output. So im thinking I need to add the OR function but have no idea how to put it in there...
When I have done this I will also want to do the same for another column looking for 06:30 and output "Open"... but that will be the same formula just different cells and output right??
Any help would be great....
Thanks
Bookmarks