| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assign a code to a range of time
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I assign range to variant and use | Excel Discussion (Misc queries) | |||
| I want to assign a value to the letter R in a cell range | Excel Worksheet Functions | |||
| Cannot assign a range to seriecollection values | Charts and Charting in Excel | |||
| assign a value to a range | Excel Discussion (Misc queries) | |||
| assign value for period of time | Excel Discussion (Misc queries) | |||
Threaded Mode
