Dec 13 2021 07:33 AM
Hello all -
I'm trying to set up a document in a shared, online Excel document that will allow employees to be scanned in and out to track their time. Because I'm using the online version of Excel, I can't use VBA.
I have attached a sample spreadsheet showing what I want to do. I have created barcodes for all my employees. When someone is scanned in, their name appears in column A and their "time in" automatically shows up in column B. When they are scanned a second time, their "time out" appears in column C. The next time they are scanned, it shows up as a "time in," and so on.
I can do all this with VBA, but I'm hoping there's also a way to do it using formulas.
Any help would be appreciated. Thank you.
Dec 14 2021 05:06 AM