Hi wolfkillj thank you for helping me find solution to my problem.

i tried your script and it was ok, but i found something wrong. I tried to add 1 log for Rebecca which is same day of 2013-9-21 23:10:00.

this what i got

001Alvin 2013-09-21 06:30:00.0002013-09-21 17:50:00.000

002Rebecca2013-09-21 22:10:00.0002013-09-21 23:10:00.000

002Rebecca2013-09-21 23:10:00.0002013-09-22 07:30:00.000

which should be like this.

001Alvin 2013-09-21 06:30:00.0002013-09-21 17:50:00.000

002Rebecca2013-09-21 22:10:00.0002013-09-22 07:30:00.000

meaning no matter how many times they punch the reader still need to get the first in and the last out of the employee.

thanks.