In your selection, workers A and B have exactly the same times and the are 3 lot numbers meeting the interval match, so for worker names and lots together you get 6 valid entries.
To get only 3, you'd need an additional condition to match worker name and lot.
In your selection, workers A and B have exactly the same times and the are 3 lot numbers meeting the interval match, so for worker names and lots together you get 6 valid entries.
To get only 3, you'd need an additional condition to match worker name and lot.
Thank You. Unfortunatelly I have the same dates for more than a worker. I was thinking that could have some trick to get the data without this duplication. I think I´ll agroup all data at the final of my script to solve the problem.
