Check if the picture answers your question:
http://img32.imageshack.us/img32/8118/nonameme.png
Micky


"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