VBA to call first and last clock in only and delete the rest

[04011988]

Hi,

I have another question here that hope you can assist me.

I have an extract of raw data from our bundy clock containing the clock in and out of employees per day. However, I am not sure how to put it in VBA - as I only need to capture the first and latest time (e.g for Name A - 6:21 and 12:39 only). Then after filtering those, I need to filter it by Name to all dates too as I need to send that to all employees for confirmation. Hope you can help me. Thanks in advance.

Dept	User ID	Name	Enroll ID	Device ID	Place	Date	Time	Att Type
ABC	_f_00013	A	13	2	Entrance Door	2018-09-14	06:21	Clock-in
ABC	_f_00013	A	13	1	HR Dept.	2018-09-14	09:49	Out
ABC	_f_00013	A	13	1	HR Dept.	2018-09-14	09:51	Out
ABC	_f_00013	A	13	1	HR Dept.	2018-09-14	12:16	Out
ABC	_f_00013	A	13	2	Entrance Door	2018-09-14	12:39	Clock-in
ABC	_f_00016	B	16	2	Entrance Door	2018-09-14	07:35	Clock-in
ABC	_f_00016	B	16	2	Entrance Door	2018-09-14	08:30	Clock-in
ABC	_f_00016	B	16	2	Entrance Door	2018-09-14	09:46	Clock-in
ABC	_f_00016	B	16	1	HR Dept.	2018-09-14	10:21	Out
ABC	_f_00016	B	16	2	Entrance Door	2018-09-14	12:03	Clock-in
ABC	_f_00016	B	16	1	HR Dept.	2018-09-14	13:22	Out
ABC	_f_00031	C	31	2	Entrance Door	2018-09-14	06:16	Clock-in
ABC	_f_00031	C	31	2	Entrance Door	2018-09-14	06:16	Clock-in
ABC	_f_00032	D	32	2	Entrance Door	2018-09-14	02:38	Clock-in
ABC	_f_00032	D	32	1	HR Dept.	2018-09-14	06:23	Out
ABC	_f_01013	E	1013	2	Entrance Door	2018-09-14	05:45	Clock-in
ABC	_f_01013	E	1013	1	HR Dept.	2018-09-14	07:58	Out
ABC	_f_01013	E	1013	2	Entrance Door	2018-09-14	08:00	Clock-in
ABC	_f_01013	E	1013	1	HR Dept.	2018-09-14	08:50	Out
ABC	_f_01013	E	1013	2	Entrance Door	2018-09-14	08:53	Clock-in
ABC	_f_01013	E	1013	1	HR Dept.	2018-09-14	09:42	Out
ABC	_f_01013	E	1013	2	Entrance Door	2018-09-14	09:45	Clock-in
ABC	_f_01013	E	1013	2	Entrance Door	2018-09-14	10:21	Clock-in
ABC	_f_01013	E	1013	1	HR Dept.	2018-09-14	12:17	Out
ABC	_f_01013	E	1013	2	Entrance Door	2018-09-14	12:19	Clock-in
ABC	_f_01013	E	1013	1	HR Dept.	2018-09-14	13:38	Out
ABC	_f_01013	E	1013	2	Entrance Door	2018-09-14	13:40	Clock-in

<colgroup><col span="2"><col><col span="2"><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[Logit]

.
https://www.exceltip.com/excel-date...login-and-last-logout-times-of-employees.html

 

[04011988]

.
https://www.exceltip.com/excel-date...login-and-last-logout-times-of-employees.html

sorry been sick and just check your response now. and thank you so much.

I will try to follow it. is it possible to do it in VBA also?

 

[04011988]

sorry been sick and just check your response now. and thank you so much.

I will try to follow it. is it possible to do it in VBA also?

Hi, Tried the formula but it is not working.

Hope you could please help me further. Thanks