Need date wise In and out time for employee ID

Hi ,

Iam new to this VBA codes and am a begineer now. I just started to write very small codes now.
But i have some urgent task to be complete ,so pls help me in getting this done.

I have a raw data as given below with three fields Date/Time,Emplyee ID and Doorname.
Date/Time Employee ID Door name
3/19/2013 6:06:44 PM 2165631 CHN-DLF-2F-MAIN REC-OUT
3/19/2013 4:52:58 PM 2165631 CHN-DLF-2F-MAIN REC-IN
3/19/2013 4:03:29 PM 2165631 CHN-DLF-2F-MAIN REC-OUT
3/19/2013 10:18:16 AM 2165631 CHN-DLF-2F-MAIN REC-IN
3/18/2013 5:57:21 PM 2165631 CHN-DLF-2F-MAIN REC-OUT
3/18/2013 4:36:09 PM 2165631 CHN-DLF-2F-MAIN REC-IN
3/18/2013 4:12:02 PM 2165631 CHN-DLF-2F-MAIN REC-OUT
3/18/2013 10:30:23 AM 2165631 CHN-DLF-2F-MAIN REC-IN
3/19/2013 6:37:37 PM 2167122 CHN-DLF-2F-MAIN REC-OUT
3/19/2013 4:53:00 PM 2167122 CHN-DLF-2F-MAIN REC-IN
3/19/2013 4:03:30 PM 2167122 CHN-DLF-2F-MAIN REC-OUT
3/19/2013 10:29:11 AM 2167122 CHN-DLF-2F-MAIN REC-IN

I need a output as with each employee ID what is the least check in time and maximum checkout time by correlating column c with column A day wise as below.

EmployeeID 19/03/2013(IN) 19/03/2013(OUT) 18/03/2013(IN) 18/03/2013(OUT)
2165631 3/19/2013 10:18:16 AM 3/19/2013 6:06:44 PM 3/18/2013 10:30:23 AM 3/18/2013 5:57:21 PM

2167122 3/19/2013 10:29:11 AM 3/18/2013 5:57:21 PM NO DATA NO DATA

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.