I need a simple Excel Macro to control employees' attendance and tardiness. I have to be able to create the employee database which will include first and last name and also personal id number. Done that, each employee must punch in and punch out when they come into and out of work, but from one computer only. Basically they will show up on a pc next to me and punch in and out by typing their id number and clicking on the button "punch". The system must immediately record the current date and time and place it on a cell on the spreadsheet, corresponding to each worker. People might work one 8 hour shift per day, or two 4 hour sifts per day, so consider that. Also, they might come in at 12 and leave at 8pm, or they might come in at 8pm and leave at 3am (the next day), so consider this as well. You should make two different files, one for weekly tracking and one for monthly tracking, since some get paid on a weekly basis and others on a monthly basis.
Also, I need to be able to manually add the schedule that each worker must follow, so when he or she punches in and out, the system will know if he or she is late, early, working extra hours, how many hours.
If the employee works between 0 and 5:59:59 hours, it is an "A" day. If they work between 6:00:00 and 7:59:59 hours, it is a "B" day. If they work more than 8 hours, then it is a "C" day. For example, if today a person works 7 hours, then he or she falls into the B category, and gets paid a certain amount of money; if they work 3 hours today, then they get paid for working an A day, and if they work 8 or 9 or 10 hours then they get paid for a C day. A, B and C days pay differently. Remember, there are sometimes two shifts, so on one same day, a person can work an A shift and a C shift as well, both within the same calendar day.
Once all the information is created and recorded, I need some simple way to filter individual workers and check all their data without searching manually among all the workers.