Forum Discussion

TheAntony's avatar
TheAntony
Iron Contributor
Aug 03, 2020

dank1868 , could use a bit more explanation. For example,

 

Here's one employee's details from Sheet1:

 

  Employee NumberfirstlastName Status DescriptionChange Type7
456061355RobertContrerasContreras, Robert15CLOCK IN/PRE-TRIPManual2020-07-29 05:53:49
456061355RobertContrerasContreras, Robert15IN SERVICEManual2020-07-29 06:02:56
456061355RobertContrerasContreras, Robert15OUT OF SERVICEManual2020-07-29 16:02:10
456061355RobertContrerasContreras, Robert15CLOCK OUTManual2020-07-29 16:22:10

 

Here's the same employee's information from Sheet2:

NameHomePltOnDutyPunchInPunchOutShiftPPDDOT
Contreras, Robert715YES2020-7-29 5:50 14.1736.6736.67
   2020-7-27 0:502020-7-27 13:0712.28  
   2020-7-28 5:352020-7-28 15:4810.22  
   2020-7-29 5:50 14.17  

 

How would you want your final data to look like when these 2 are brought together? 

 

Resources