Probably the program as such is not so much a problem. Question remains how you want to set up your system. Can people just log-in and log-out any moment they like? Do you use card readers, giving everybody a pass? Do you connect through log-in at the computer and log-out automatically as well. This would require everybody using a workstation and turning it on and off each working day. Do you apply a special program? Will it be pass word protected or can everybody do a ?favour? for somebody else? Can they just enter times themselves? Would it be taken from the system clock? The local one, which easily can be set to another value, or from the server? How do you want to cope with ?errors?, such a forgetting to log-in, log-out, double log-in and out? Leaving time before entering time? Are there special rules for overtime? Vacation, or a day off? Should that be logged as well? These issues are of much more importance than anything else. Once you have gathered the data and analyzed these for correctness it would be easy to consolidate the data in either Excel or Access, or similar products. Most vendors of card readers supply some programs as well.
Making a good program to analyze all possible mistakes is another story.
Perhaps thiswas not the answer you were looking for. However, these issues should be resolved first before designing spreadsheets.
Good luck.
