I use a scanner in my classroom to record attendance. Students highlight the
cell next to their name on a roster then scan their ID. It enters their ID
number in the cell. I would like the time the card was scanned to show up
instead. I played around with the If and Now formulas but could not get it to
work. I'm thinking of a macro that whenever any value is entered in the cell
it shows time instead. Any ideas?