I want to scan the students (they have barcode stickers) in our cross country event when they come back across the line. I want excel to get the barcode and grab the system time and correspond it to the barcode.
I don't want to use a macro as that is a keystroke after the scan. I can do it with a function using NOW() but every time I add another entry it updates all the times, volatile. How can I get to keep the time it first gets instead of updating all the time?
I don't want to use a macro as that is a keystroke after the scan. I can do it with a function using NOW() but every time I add another entry it updates all the times, volatile. How can I get to keep the time it first gets instead of updating all the time?