Hi, I have a table that has information of the employees from an industry and they have to register each time they started working and they work for 6 hours each time. This rotation is registered as a number this way:
rotation 1 begins at 07:00
rotation 2 begins at 13:00
rotation 3 begins at 19:00
rotation 4 begins at 01:00
The employees work for projects that has date/time of the beginning and the ending.
Each employee registers for a specific equipment.
As some employes has delays or even forget to register sometimes, I have to control if the employees have registered correctly.
My input table is the project master data that contains the project number, the equipments used, the beginning date/time and the ending date/time.
My result table must contain the project number, the equipment and all the records of each rotation to compare with the employees registers.See that I need only the rotation between the initial and ending date.
