Pecoflyer,
Oh, Wow, I would never have figured this one out. (I think I love you too!) This would be much better as the Check_In file is a report that comes directly from the Check In Software (Days of week included) and I need it as clean as possible for the people who will be managing this. Not having to add the helping column is a huge plus.

Only one problem, however, it returns a 12:00 time whenever there is no data in the [Check_In]EmployeeData! I need for that to either, be blank or return a #N/A as that is one of the crucial items that needs to be tracked (whether they just didn't check in bc they were late, forgot, etc).

Is there a way to resolve this?

Also, It worked without a Cntrl-Shft-Enter....but I did it both ways to check.
Can you enlighten me there as well?

Guess you can see that I am just a user, not a guru like you and Bob.