Populate a cell with a value if time falls within a certain range

[XLVBA]

I have a spreadsheet with about 3100 rows. Column B contains dates and column C contains times.

I need to find out if the time in Column C falls between a range of times and then depending what range of times it falls in, I would like it to return a value into Column D. The time ranges and values I would like returned are as follows:

Between 6:01 AM - 8:00 AM should return "Early"
Between 8:01 AM - 11:00 AM should return "Morning"
Between 11:01 AM - 3:00 PM should return "Afternoon"
Between 3:01 PM - 10:00 PM should return "Evening"
Between 10:01 PM - 6:00 AM should return "Overnight"

So for example: C2 = 8:03 AM, I would like it to put "Morning" in D2.

[jeffreybrown]

Would this work for you in a lookup table?

D1 =LOOKUP(E1,A1:B5)

Please Login or Register  to view this content.

[XLVBA]

I didn't even think to do it as a lookup, I kept thinking more complicated than it really needed to be. Works great. Thank you!

[jeffreybrown]

I know what you mean, I often do the same thing.

You're very welcome...glad you got it all sorted out and thanks for the feedback