Barcode scanner timing to excel
- by Claire
I have a barcode reader that will load the barcode to a excel spreadsheet - great - but now i need it to do 2 things:
1 - add a time stamp to next to the barcode that has been scanned. So Barcode goes to A1, need B2 to show time.
2- find the name (that is in a seperate excel sheet) that is linked to that barcode and add it to C1, next to the time and barcode.
I use this method to time trail running - each person is issued a barcode and as they go through various points their barcode is scanned and a time is allocated to their name.