Excel solution for access control.

Hi there,

I have the below data extracted from a building access control system. this shows when an employee enters or leaves the building. for fire safety, i need to create a spreadsheet which will tell me the current status of each employee. I need the spreadsheet to allow me to paste the data into it and i was hoping to be able to press a button to run a formula/macro to give me a list which shows the current status of each employee only.

Any help is appreciated.
Thanks for taking time to read this.
Kind regards.

Column A Column B Column C Column D Column E Column F
Date/Time Tag Holder Event Device Name Transaction Type Direction
10/12/2014 07:47 ACCOGLI, F Allowed Normal In Turnstile 2 (IN) Access Out
10/12/2014 08:33 ACCOGLI, F Allowed Normal Out Turnstile 1 (OUT) Access In
10/12/2014 08:44 ACCOGLI, F Allowed Normal In Turnstile 1 (IN) Access Out
10/12/2014 07:29 ACHESON, C Allowed Normal In Turnstile 1 (IN) Access Out
10/12/2014 08:59 ACHESON, C Allowed Normal Out Turnstile 1 (OUT) Access In
10/12/2014 09:24 ACHESON, C Allowed Normal In Turnstile 2 (IN) Access Out

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

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

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Here, try this:
On sheet one enter data
On sheet 2 is result (yellow cells, extend down as needed)

if doesn't work provide some example on your own.

No need for spliting.
I just copy paste your data from post #1 and there is not clear that date and time is in same cell.

Here, try this solution.
With this approach is not needed that dates/times are in order. - it will return latest time no matter where it is.