On Jan 7, 6:04 pm, Bret Bernever wrote:
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

Bret,

The easiest thing would be to set up a simple VLookUp table like this:

0 4
6 1
8 2
18 3
22 4

The lookup value are the hourly slots. Set the range lookup of the
function to TRUE Use HOURS(TimePeriod) as the lookup value for each
time entry in your data set. That will associate each Time Period
with the appropriate Time Slot. Then you can do what you intend with
the info.

SteveM