Hi,
I need help with finding first swipe in and last swipe out of the advisor. Also, if possible, can we calculate the total floor time & break of the advisor. I'm also having trouble with nightshift advisors.
I need help with finding first swipe in and last swipe out of the advisor. Also, if possible, can we calculate the total floor time & break of the advisor. I'm also having trouble with nightshift advisors.
Swipe In.out.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | |||
4 | Date and time | Entry type | Empid | Swipe | Night Shift | |||
5 | 24-04-24 6:01:00 AM | valid entry | 18565 | In | 12687 | |||
6 | 24-04-24 6:03:00 AM | valid entry | 13872 | In | 12689 | |||
7 | 24-04-24 6:06:00 AM | valid entry | 14716 | In | 12688 | |||
8 | 24-04-24 7:06:00 AM | valid entry | 12226 | In | ||||
9 | 24-04-24 8:06:00 AM | valid entry | 16891 | In | ||||
10 | 24-04-24 9:06:00 AM | valid entry | 18433 | In | ||||
11 | 24-04-24 10:06:00 AM | valid exit | 14716 | Out | ||||
12 | 24-04-24 11:06:00 AM | valid exit | 12226 | Out | ||||
13 | 24-04-24 12:06:00 PM | valid exit | 16891 | Out | ||||
14 | 24-04-24 1:06:00 PM | valid entry | 14716 | In | ||||
15 | 24-04-24 2:06:00 PM | valid entry | 12226 | In | ||||
16 | 24-04-24 3:06:00 PM | valid entry | 16891 | In | ||||
17 | 24-04-24 4:06:00 PM | valid entry | 16891 | In | ||||
18 | 24-04-24 5:06:00 PM | valid exit | 18565 | Out | ||||
19 | 24-04-24 6:06:00 PM | valid exit | 18433 | Out | ||||
20 | 24-04-24 7:06:00 PM | valid exit | 13872 | Out | ||||
21 | 24-04-24 8:06:00 PM | valid exit | 13872 | Out | ||||
22 | 24-04-24 9:06:00 PM | valid entry | 12687 | In | ||||
23 | 24-04-24 10:06:00 PM | valid entry | 12689 | In | ||||
24 | 24-04-24 11:06:00 PM | valid entry | 12688 | In | ||||
25 | 25-04-24 12:06:00 AM | valid entry | 12690 | In | ||||
26 | 25-04-24 1:06:00 AM | valid exit | 12687 | Out | ||||
27 | 25-04-24 2:06:00 AM | valid exit | 12689 | Out | ||||
28 | 25-04-24 3:06:00 AM | valid entry | 12690 | In | ||||
29 | 25-04-24 4:06:00 AM | valid entry | 12691 | In | ||||
30 | 25-04-24 5:06:00 AM | valid exit | 12687 | Out | ||||
31 | 25-04-24 6:06:00 AM | valid exit | 12689 | Out | ||||
32 | 25-04-24 7:06:00 AM | valid exit | 12688 | Out | ||||
33 | 25-04-24 8:06:00 AM | valid exit | 18565 | Out | ||||
34 | 25-04-24 9:06:00 AM | valid exit | 13872 | Out | ||||
35 | 25-04-24 10:06:00 AM | valid exit | 14716 | Out | ||||
36 | 25-04-24 11:06:00 AM | valid exit | 12226 | Out | ||||
37 | 25-04-24 12:06:00 PM | valid entry | 16891 | In | ||||
38 | 25-04-24 1:06:00 PM | valid entry | 18433 | In | ||||
39 | 25-04-24 2:06:00 PM | valid entry | 14716 | In | ||||
40 | 25-04-24 3:06:00 PM | valid entry | 12226 | In | ||||
41 | 25-04-24 4:06:00 PM | valid entry | 16891 | In | ||||
42 | 25-04-24 5:06:00 PM | valid entry | 18433 | In | ||||
Sheet1 |