If Question

  • Thread starter Thread starter Tango
  • Start date Start date
T

Tango

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
 
You could use an "IF" statement. Suppose cell A2 has the time in it:

=IF((A2>TIME(9,0,0))*(A2<=TIME(14,0,0)),"lunch","Dinner")
 
Back
Top