Forum Discussion
Excel sheet for clocking in/out
Hello,
I am still new to using excel more in depth and was looking to see if I could create a sheet that would clock people in and out?
I have a barcode scanner that I will be using, each individual will have their own unique barcode. I would ideally want column A to be the name (and also where they would scan the barcode) and I would want column B to be the clock in time, so that when column a is scanned the time is automatically generated. Column C would then be their clock out time (that again is automatically generated when the barcode is scanned).
I am not sure if something like this is possible or something that is similar to these functions. As long as I am able to scan in one column and have a time stamp populated next to that column it would help a lot.
If any one knows how i am able to do this or what formulas would be good to use?
1 Reply
So I don't like the idea of having all of their barcodes in the spreadsheet because:
a) they can accidentally scan the wrong name
b) they could intentionally scan the wrong name
I would (IMHO) have their barcodes on their badge or keyfob or whatever and then they scan that (a backup binder with all of their codes or electronically in a different spreadsheet could be available in case they forgot their badge/keyfob)
But since you have a BarCode font (or if not you can download one for free), I would create a Log sheet with 3 columns:
ID Date/Time In/Out
and on the top of the sheet have 3 cells: Date/Time (=NOW() ), In, Out each of them shown in the BarCode font
Then they scan the badge which should hopefully cause Excel to update the cell with NOW() so then they scan the Date/Time (i.e. NOW()) cell and then either the barcode for IN or the barcode for OUT.
Then elsewhere you can connect the ID to the people and their clock in and clock out times.
Here is an image of what I'm imagining but sure you could improve on it:
then in another sheet you can summarize each employee's times.
