Mapping 2 data within a range as criteria

[reignM]

Hi. I have the following simplified 2 data sources:  

Session	Date	Timing	Title
1	3 May	0800 - 0830	Title A
2	5 May	0900 - 0930	Title B
1	3 May	0900 - 0930	Title C
3	4 May	0800 - 0900	Titile D
1	5 May	1230 - 1230	Title E

ID	Session	Date	Start Time	End Time
1234	1	3 May	0822	0845
4567	3	4 May	1010	1012
8910	1	5 May	1236	1259
1112	1	3 May	0920	0930

What I wish to do is to find the Title to each ID given the Start Time, End Time, Session and Date. So in this case, for ID 1234, the title would be Title A. The first data table signify the schedule. I wish to find out the Title which ID tune in to based on the schedule. 

If the start time and End time falls within the Timing range, and have the same Session and Date, I am to map the Title.

What I did was to split the Timing into 2 columns. But the problem i'm facing is when I attempt to use 'Join' to match the Timing against the Start Time and End Time, it could not have work since they are not identical. 

How do i go about doing this? I would greatly appreciate your help.

[DavidSkaife]

Hi @reignM 

It's a bit rough but this should work, and give you an idea on how to approach it (i assume Title A timing should have been 0800 - 0900 if you're saying it should be a match):

[binuacs]

@reignM Another way of doing with this by generating the time range using the Generate Tool and compare with the start time