E
Elizabeth
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!
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!