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,
