Presumably, you won't have any times before 5:00 am or after 7:00pm?
This is a nice little problem, but it's a bit late here in the UK so I
haven't got time to delve into it. If you haven't had any solutions by
the morning, I'll look at it then. I think you just need a simple
table of times and codes, and an IF to give you the composite codes.

Pete

On Oct 26, 1:25 am, Elizabeth
wrote:
I need to figure out how to assign a code in a separate cell to a range of
time. Here's part of the codes I need to use (the last column being the code
for any times within that range of time:
5:01 AM 9:00 AM 1
9:01 AM 11:00 AM 2
11:01 AM 1:00 PM 3
1:01 PM 3:00 PM 4
3:01 PM 5:00 PM 5
5:01 PM 7:00 PM 6

BUT, I need to be able to allow for multiple answers in one cell. Here's an
example of what I need it to do:

12:00 AM 8:55 AM 1
8:55 AM 9:05 AM 1, 2
9:05 AM 9:55 AM 2
9:55 AM 10:05 AM 2
10:05 AM 10:25 AM 2
10:25 AM 12:00 PM 2, 3
12:00 PM 12:30 PM 3

This is for a research project that has do be done by Monday, can someone
help? I'm mildly computer literate but would need mostly laymans language.
HELP!

--
Elizabeth