Advisor login, logout & break calculation

[nmaske]

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.

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

 

[Cubist]

There are multiple instances of in and out of an EmpID how do you determine floor time and break time? It'd be helpful if you can do a manual calculation for one person as an example.