Hello,
I have a sheet with columns: Date , Sign in, Sign out, Emp ID and another sheet with Dates and Emp ID.
I want to have the sign in and sign out times if the dates and Emp IDs match on both the sheets.(
)
I have attached a sample sheet below for reference.
I want to populate the sign in -sign out times for Emp IDs if the dates match.
Thanks in advance
I have a sheet with columns: Date , Sign in, Sign out, Emp ID and another sheet with Dates and Emp ID.
Employee ID | Date | Time | Event | Sign in | Sign out |
0 | 2020-12-04 | 13:50:08 | Exit | 13:50:08 | |
0 | 2020-12-04 | 13:52:25 | Exit | 13:52:25 | |
701124 | 2020-11-30 | 13:31:30 | Entry | 13:31:30 | |
701124 | 2020-11-30 | 21:21:12 | Exit | 21:21:12 | |
701124 | 2020-12-01 | 13:29:16 | Entry | 13:29:16 | |
701124 | 2020-12-02 | 13:14:24 | Entry | 13:14:24 | |
701124 | 2020-12-03 | 13:35:28 | Entry | 13:35:28 |
I want to have the sign in and sign out times if the dates and Emp IDs match on both the sheets.(
Date | Sign In | Sign out | Emp. # |
10/25/20 | 718025 | ||
10/25/20 | 702195 | ||
10/25/20 | 702800 | ||
10/23/20 | 707349 | ||
10/25/20 | 731102 | ||
10/25/20 | 732603 | ||
10/26/20 | 712931 | ||
10/27/20 | 708649 | ||
10/25/20 | 701124 |
I have attached a sample sheet below for reference.
I want to populate the sign in -sign out times for Emp IDs if the dates match.
Thanks in advance