Hi,

I'm looking to make a spreadsheet that will basically tell me when an employee arrives and leaves work. We use RFID badges for access thought the building so I'd be looking for a way to have the employees scan their badges so it inputs their badge ID into a cell, perhaps based on the badge ID it would then enter the employee names then automatically enter the time and date. The cell would need to then be locked so employees cannot edit the generated time/date.

any help would be appreciated.