Value Based On A Time Before OR After

[fotodude]

Hello,
I have a question in regards of times. I feel like it should pretty simple but I did a let of research and trying but nothing really works out


Lets say I have times in Column A and based on those times I would like to show either Lunch or Dinner based if the time is passed 3pm.
for example
5:34 pm Dinner
3:23 pm Dinner
1:23 pm Lunch
7:00 am Lunch

Any help is appreciated.
Thanks,
Martin

[benishiryo]

hi there, martin. Excel recognises dates as integers & time as decimals. to verify, type in 1jan2013 in A1. and 12 pm in B1. Format both cells to General. you will see that A1 is 41275 (meaning 41,275th day from 1 Jan 1900) & B1 is 0.5 (1/2 a day).

hence, you can check for time by doing:
=IF(A2>15/24,"Dinner","Lunch")
15/24 is 3 pm. just like how 12/24 is 12 pm.

your cells might have contain date too, but formatted to exclude showing it. you would then have to use:
=IF(MOD(A2,1)>15/24,"Dinner","Lunch")

[fotodude]

Hi Benishiryo,
Thanks for the help and great explanation.
Thanks again,
Martin