You could use an "IF" statement. Suppose cell A2 has the time in it:

=IF((A2TIME(9,0,0))*(A2<=TIME(14,0,0)),"lunch","D inner")



"Tango" wrote:

Hi,

I have a column with times in it

11:28:46 AM
11:29:21 AM
11:29:50 AM
11:44:03 AM
11:44:10 AM
11:44:25 AM
& would like to add the value Lunch or Dinner depending on wether the time
is between say 9:00:00 AM and 2:00:00 PM for Lunch & 2:00:01 PM and 11:59:59
PM

thanks in advance