We use the same magnetic card reader for access to our building and time card clock in and out. The system provides output (see the CSV file attached) that includes the employee number, time/date of clock in and place of clock in (a bunch of stations; but the ones that are "in" clocks are prefixed with a I+ and the ones that are out are prefixed with a O+).
Clock in/outs less than 2 minutes between are discarded. Otherwise, we need to calculate the hours on the job by totaling the hours per day....which obviously means calculating the difference bewteen clock in/out by employee. The gross hours should be loaded into a MS SQL DB. With the following: EmployeeNumber, date, rounded hours total (rounded up to the nearest 5 minutes). Of course, if people forget to clock in/out, that's where we have problems, so the idea is to use a active server pages or .NET database browser (a web browser front end) to display the employee number, date, hours worked in some kind of a format that the manager can correct, just simple corrections, for example, if the employee clocked in at 8am, clocked out at lunch but forgot to clock back in, then clocked out at 5pm, then they'd have 4 hours, but would need to show the correctable error on a web browser viewer of the database. the manager should just be able to manually correct the time.
If this project goes well, we have a ton of other work.