| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming;,microsoft.public.excel.newusers
|
|||
|
|||
Splitting up timeperiod
I have 4 Timeslots:
TimeSlot 1 - 6:00-8:00 TimeSlot 2 - 8:00-18:00 TimeSlot 3 - 18:00-22:00 TimeSlot 4 - 22:00-6:00 I have one time period: TimePeriod - 17:00-1:00 Question: I want to split the time period in the appropriate timeslots so that the results should be: 17:00-18:00 - Falls in TimeSlot 2 18:00-22:00 - Falls in Time Slot 3 22:00-1:00 - Falls in TimeSlot 4 Any ideas how to accomplish that? I'm interested in the explicit timeintervals: 17:00-18:00 18:00-22:00 22:00-1:00 not the hours count! Thanks in Advance Bret Bernever |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting a cell | New Users to Excel | |||
| splitting Last Name, First Name | Excel Discussion (Misc queries) | |||
| Splitting names | Excel Discussion (Misc queries) | |||
| Splitting Panes | Excel Discussion (Misc queries) | |||
| Splitting Rows | New Users to Excel | |||
Threaded Mode
