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

04011988

New Member
Joined
Sep 23, 2018
Messages
26
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.

DeptUser IDNameEnroll IDDevice IDPlaceDateTimeAtt Type
ABC_f_00013A132Entrance Door2018-09-1406:21
Clock-in
ABC_f_00013A131HR Dept.2018-09-1409:49
Out
ABC_f_00013A131HR Dept.2018-09-1409:51
Out
ABC_f_00013A131HR Dept.2018-09-1412:16
Out
ABC_f_00013A132Entrance Door2018-09-1412:39
Clock-in
ABC_f_00016B162Entrance Door2018-09-1407:35Clock-in
ABC_f_00016B162Entrance Door2018-09-1408:30Clock-in
ABC_f_00016B162Entrance Door2018-09-1409:46Clock-in
ABC_f_00016B161HR Dept.2018-09-1410:21Out
ABC_f_00016B162Entrance Door2018-09-1412:03Clock-in
ABC_f_00016B161HR Dept.2018-09-1413:22Out
ABC_f_00031C312Entrance Door2018-09-1406:16Clock-in
ABC_f_00031C312Entrance Door2018-09-1406:16Clock-in
ABC_f_00032D322Entrance Door2018-09-1402:38Clock-in
ABC_f_00032D321HR Dept.2018-09-1406:23Out
ABC_f_01013E10132Entrance Door2018-09-1405:45Clock-in
ABC_f_01013E10131HR Dept.2018-09-1407:58Out
ABC_f_01013E10132Entrance Door2018-09-1408:00Clock-in
ABC_f_01013E10131HR Dept.2018-09-1408:50Out
ABC_f_01013E10132Entrance Door2018-09-1408:53Clock-in
ABC_f_01013E10131HR Dept.2018-09-1409:42Out
ABC_f_01013E10132Entrance Door2018-09-1409:45Clock-in
ABC_f_01013E10132Entrance Door2018-09-1410:21Clock-in
ABC_f_01013E10131HR Dept.2018-09-1412:17Out
ABC_f_01013E10132Entrance Door2018-09-1412:19Clock-in
ABC_f_01013E10131HR Dept.2018-09-1413:38Out
ABC_f_01013E10132Entrance Door2018-09-1413:40Clock-in

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

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

04011988

New Member
Joined
Sep 23, 2018
Messages
26
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,020
Messages
5,526,293
Members
409,694
Latest member
bastos21

This Week's Hot Topics

Top