TIME and IF function

[Mediaexcel]

I am trying to categorize some of my data by time segments
i.e.

6PM-12AM = EVENING
12AM-6AM = NIGHT
6AM-12PM = MORNING
12PM-6PM = AFTERNOON

Column A would have the exact time and column be would have one of th
four categories.

I previously used the follwing formula but can't figure out how to ad
two more variables.

=IF(AND(E122<TIME(23, 59, 59),E122>TIME(18, 0, 0)),"EVENING","OTHER")

Thank yo

 

[JE McGimpsey]

Since XL stores times as fractional days (e.g., 3:00 = 0.125):

=CHOOSE(INT(A1*4)+1,"NIGHT","MORNING","AFTERNOON","EVENING")

 

[Mediaexcel]

Thank you,
it worked perfectly!

: