Creating a digital In/Out accountability tracker...setting status to in/out automatically

Good evening friends,

I am looking to build a digital version of the ancient manual logbooks currently used to track personnel entering/exiting our facility. I currently have badges with barcodes and scanners that capture personal information (Name, employee ID number, department), and use a formula to create a timestamp for when the badge is scanned (Data collection is operational). Because of the frequency of employees and visitors entering and exiting the facility, I'd like to do two things;

1) translate some of this timestamp data to indicate whether an employee or visitor is "In" or "Out" of the building,

2) Create and record a list of visitors who have entered the building during that day (I have 5 employees, and may have up to 15 visitors per day that will enter/depart numerous times. Because of this I'd like to create a list of 'unique' employee ID numbers and their associated names).

Currently I can create a "Dashboard" (displayed in G2:I6 of the attached) which displays the status of all known employees...I am using a CountIf formula which counts the number of times an employee has scanned their badge within a given time period; if the result is 0 or an even number, the employee is "Out" of the building, if the result is odd the employee is "in" the building. This is logical however, I'd still like to be able to record the individual status of each check-in or check-out based upon previous entries. How do you suggest I do that (depicted in column E of the attached)?

As for part 2, I have no idea how to lookup and create a list of unique visitors who are not employees from another list. Any help would be appreciated!

Thanks in advance!
-Mike

Dave

Thank you! This resolves question 1, but leaves some room for learning with question 2;

I am not familiar with array-entered formulas, however, I'd like modify the results a bit. In attempting to do so myself...I break it (LOL).

I'd like the visitors names to appear in beginning in G9, and much like the personnel list above would like to display Scan count in H9, and Status in I9; the next unique visitor would be in G10, then G11, etc.

Lastly, I'd like to be able to search up to 100ish potential entries, (assuming this is the range of the array) for visitors who might enter the building throughout the day. As an example, if in A17:E17 is filled out with "Doug", the Visitors dashboard would now display info for both Mark and Doug. Is there a way to accomplish this?

Thanks again for all your assistance.
-Mike