Date recognition between start and end dates

[George1973]

Hello everyone,
I have two tables. One shows production data:

Start Time Actual	Stop Time Actual	Production Line	Hrs Actual	Break Hrs
9-13-21 8:00 AM	9-13-21 8:30 AM	Line 1	0.50	???
9-13-21 9:30 AM	9-13-21 8:00 PM	Line 2	10.50
9-13-21 8:00 PM	9-14-21 5:00 AM	Line 2	9.00
9-14-21 6:00 AM	9-14-21 8:00 AM	Line 1	2.00
9-14-21 8:00 AM	9-14-21 8:00 PM	Line 3	12.00
9-14-21 8:00 PM	9-15-21 5:00 AM	Line 4	9.00
9-15-21 6:00 AM	9-15-21 8:00 AM	Line 1	2.00
9-15-21 8:00 AM	9-15-21 9:50 AM	Line 4	1.83
9-15-21 10:50 AM	9-15-21 5:15 PM	Line 1	6.42
9-15-21 6:15 PM	9-15-21 8:00 PM	Line 2	1.75
9-15-21 8:00 PM	9-16-21 8:00 AM	Line 2	12.00
9-16-21 8:00 AM	9-16-21 6:30 PM	Line 1	10.50
9-16-21 7:30 PM	9-16-21 8:00 PM	Line 3	0.50
9-16-21 8:00 PM	9-17-21 4:00 AM	Line 4	8.00
9-17-21 5:00 AM	9-17-21 8:00 AM	Line 1	3.00
9-17-21 8:00 AM	9-17-21 1:30 PM	Line 1	5.50
9-17-21 2:30 PM	9-17-21 6:40 PM	Line 1	4.17
9-17-21 7:40 PM	9-17-21 8:00 PM	Line 1	0.33
9-17-21 8:00 PM	9-18-21 1:45 AM	Line 1	5.75
9-20-21 10:00 AM	9-20-21 8:00 PM	Line 1	10.00
9-20-21 8:00 PM	9-21-21 5:00 AM	Line 1	9.00
9-21-21 6:00 AM	9-21-21 8:00 AM	Line 1	2.00
9-21-21 8:00 AM	9-21-21 8:00 PM	Line 1	12.00
9-21-21 8:00 PM	9-22-21 4:30 AM	Line 1	8.50
9-22-21 5:30 AM	9-22-21 8:00 AM	Line 1	2.50
9-22-21 8:00 AM	9-22-21 4:55 PM	Line 4	8.92
9-22-21 8:00 PM	9-23-21 2:15 AM	Line 4	6.25
9-23-21 3:15 AM	9-23-21 6:18 AM	Line 4	3.05
9-23-21 7:18 AM	9-23-21 8:00 AM	Line 4	0.70
9-23-21 8:00 AM	9-23-21 11:38 AM	Line 4	3.63
9-23-21 12:38 PM	9-23-21 5:00 PM	Line 4	4.37
9-23-21 6:00 PM	9-23-21 8:00 PM	Line 4	2.00
9-23-21 8:00 PM	9-24-21 8:00 AM	Line 4	12.00
9-24-21 8:00 AM	9-24-21 8:30 AM	Line 4	0.50
9-24-21 9:30 AM	9-24-21 8:00 PM	Line 4	10.50
9-24-21 8:00 PM	9-24-21 10:00 PM	Line 4	2.00
9-25-21 1:00 AM	9-25-21 7:30 AM	Line 4	6.50
9-25-21 8:30 AM	9-25-21 3:20 PM	Line 4	6.83
9-25-21 4:20 PM	9-25-21 8:00 PM	Line 4	3.67
9-25-21 8:00 PM	9-25-21 10:00 PM	Line 4	2.00
9-25-21 11:00 PM	9-26-21 8:00 AM	Line 2	9.00
9-26-21 10:00 AM	9-26-21 7:30 PM	Line 2	9.50
9-27-21 10:00 AM	9-27-21 8:00 PM	Line 1	10.00
9-27-21 8:00 PM	9-28-21 2:00 AM	Line 3	6.00
9-28-21 3:00 AM	9-28-21 8:00 AM	Line 4	5.00
9-28-21 8:00 AM	9-28-21 8:00 PM	Line 1	12.00
9-28-21 8:00 PM	9-28-21 9:48 PM	Line 1	1.80
9-28-21 10:48 PM	9-29-21 8:00 AM	Line 1	9.20
9-29-21 8:00 AM	9-29-21 8:22 AM	Line 2	0.37
9-29-21 9:22 AM	9-29-21 1:30 PM	Line 2	4.13
9-29-21 2:30 PM	9-29-21 8:00 PM	Line 1	5.50
9-29-21 8:00 PM	9-29-21 8:45 PM	Line 3	0.75
9-29-21 9:45 PM	9-30-21 4:00 AM	Line 4	6.25
9-30-21 6:00 AM	9-30-21 8:00 AM	Line 1	2.00
9-30-21 8:00 AM	9-30-21 8:00 PM	Line 1	12.00
9-30-21 8:00 PM	9-30-21 10:20 PM	Line 1	2.33
9-30-21 11:20 PM	10-1-21 6:25 AM	Line 2	7.08
10-1-21 7:25 AM	10-1-21 8:00 AM	Line 2	0.58
10-1-21 8:00 AM	10-1-21 12:57 PM	Line 1	4.95
10-1-21 1:57 PM	10-1-21 8:00 PM	Line 3	6.05
10-1-21 8:00 PM	10-2-21 12:00 AM	Line 4	4.00
10-2-21 1:00 AM	10-2-21 8:00 AM	Line 1	7.00
10-4-21 9:50 AM	10-4-21 8:00 PM	Line 1	10.17
10-4-21 8:00 PM	10-5-21 7:00 AM	Line 1	11.00
10-5-21 8:00 AM	10-5-21 8:00 PM	Line 2	12.00
10-5-21 8:00 PM	10-6-21 2:25 AM	Line 2	6.42
10-6-21 3:30 AM	10-6-21 8:00 AM	Line 1	4.50
10-6-21 8:00 AM	10-6-21 8:00 PM	Line 3	12.00
10-6-21 8:00 PM	10-6-21 10:55 PM	Line 4	2.92
10-6-21 11:55 PM	10-7-21 5:00 AM	Line 1	5.08
10-7-21 5:30 AM	10-7-21 8:00 AM	Line 1	2.50
10-7-21 8:00 AM	10-7-21 12:05 PM	Line 1	4.08
10-7-21 4:25 PM	10-7-21 8:00 PM	Line 2	3.58
10-7-21 8:00 PM	10-7-21 10:05 PM	Line 2	2.08
10-7-21 10:45 PM	10-8-21 6:05 AM	Line 1	7.33
10-8-21 6:55 AM	10-8-21 8:00 AM	Line 3	1.08
10-8-21 8:00 AM	10-8-21 8:00 PM	Line 4	12.00
10-8-21 8:00 PM	10-8-21 11:00 PM	Line 1	3.00

The second, seperate table shows data about planned and unplanned breaks within this production facility:

Break Date	Production Line	Break Type	Break HRS
13-Sep-21	Line 1	Tool Change	0.2
10-Sep-21	Line 2	Failure	0.15
14-Sep-21	Line 1	Failure	0.15
15-Sep-21	Line 4	Failure	0.6
15-Sep-21	Line 3	Planned Maintenance	0.15
14-Sep-21	Line 3	Failure	0.15
14-Sep-21	Line 4	Failure	0.15
16-Sep-21	Line 4	Tool Change	0.2
16-Sep-21	Line 4	Failure	0.15
16-Sep-21	Line 1	Failure	0.15
16-Sep-21	Line 2	Planned Maintenance	0.15
20-Jun-21	Line 1	Failure	0.15
20-Jun-21	Line 4	Tool Change	0.2
20-Jun-21	Line 4	Failure	0.15
20-Jun-21	Line 2	Failure	0.15
20-Jun-21	Line 1	Failure	0.15
2-Oct-21	Line 2	Failure	0.15
2-Oct-21	Line 2	Failure	0.15
2-Oct-21	Line 1	Failure	0.15
2-Oct-21	Line 2	Failure	0.15
2-Oct-21	Line 3	Failure	0.15
4-Oct-21	Line 1	Tool Change	0.2
5-Oct-21	Line 3	Failure	0.15
6-Oct-21	Line 3	External Factor	0.2
7-Oct-21	Line 1	Planned Maintenance	0.2

I would like to to have a calculated column which (Highlighted in red):

1) recognize the proper date (time) difference between start and stop dates in production table related to break date in "Breaks Table"
2) Maches Production lines between two tables
3) Values with the proper "Break HRS" from the "Breaks table"

Thanks in advance,

[George1973]

@tamerj1 Hi,
Thanks for supporting,
Let's say, if the days match and the production lines are also met, then the Time itself does not matter. The day (date) is more important then the time..

[tamerj1]

@George1973 

Sometimes you have multiple starts and stops in the same day. The beak shall go for which one?