VB and Excel Attendance BADLY NEEDED HELP. :(

Hi guys.

I really need help regarding biometrics attendance using vb and excel..
We used biometrics in our office for attendance. Attach is the Raw log in and log out sample of the employees that is exported on Microsoft Excel.
attendance.JPG

What I need to do is through the exported Microsoft Excel file that contains the log-in and log.out, I need to extract the First Log in and Last Log out of every employee regardless of the schedule.

Because there are employees who log-in or log-out twice or thrice.

It will be placed on another excel sheet which contains the name, log-in and log out time.

Employees have different schedules, there are 6am-2pm, 2pm-10pm, 10pm-6am, 5pm-1am 9am-5pm depending on what account they belong.

I hope you can help me on this.

Please help me.

Thank you so much..

thank you so much tigeravatar! your reply helps me a lot.. can you help me translate the excel code to vba?

up! more help please!

up ! up! more help please!

You're an angel in disguise, tigeravatar! I just wanted to ask if the code is applicable to the excel file you sent earlier? or you tried the code on another excel file? I will send an excel file, which contains the data. Thank you so much for the help you extended. sample2.xlsx

Ok.. Will it be applicable to this excel file attach on this reply? sample2.xlsx thanks again!

Its working tigeravatar! Thank you so much! But my problem now is how will i use the module if I open another sheet?

Its working tigeravatar! Thank you so much! But my problem now is how will i use the module if I open another sheet? Will the Get Times button automatically appear if I copy and paste the module on another sheet? Sorry for having so many questions.

Thank you so much tigeravatar! I am worried for the past few days because of this problem but not anymore now because of the help you extended! If I have some problems again with the codes, can I still ask for your help? Would that be alright?

no problem with that! thank you again! another question tigeravatar, if I ever I wanted to know if whose late based on the extracted data, would that be possible?

ok.. i will do.. but going back to this topic, what if, there will be different dates tiger avatar? because i tried the module on data from may 15-may 17 which having different dates, the result is may 15 log.in and may 17 log.out. It should be may 15 log.in and log.out.. and may 16 log.in and log.out and may 17 log.in and log.out and so on .please see attach file. testing.xlsx hope you will still help me with this. thank you so much..

up! up! up!

please help!

Thanks tigeravatar! I opened the file. The clock in and clock out for all the employees were all the same but it should be not the same because they do have different schedules and the log in and log out were not the same..

Wow! It works perfectly! Thank you so much tigeravatar! My problem is solved! I will now close this thread! Again, thank you!

Hi tigeravatar. I have another problem regarding extracting or copying of data from one sheet to another sheet. Here's the link of the new thread I posted. I hoped you can help me.

http://www.excelforum.com/excel-prog...nce-in-vb.html

hi tigeravatar.. i hope you could help me on this new problem i posted.. here's the link of the thread http://www.excelforum.com/excel-prog...ch-in-vba.html