Time Cards - Excel Vs Access as option

[Aussiebear]

3 - don't forget the XLA.

Who completes the timesheets, the employee, or a central admin? If the former, you should create a separate workbook per employee and put in a central server directory, so the employee can update, then one of the XLA functions would be to consolidate them all. This process should also validate that the total jobs time equals the daily worked time.

BTW, the start date should be a function of the timesheet generator function, an inpout to that function.

Bob, A Farm Supervisor will be the sole data entry/ manulipulator of the data, in a Central Admin area. He gets access to the Time cards as completed by the employees and enters the data from there.

Thought about the validation of the Hours worked per day against the Functions hours, but didn't know how to do this.

The date function is firstly based on when the time cards start, (for us its a Saturday). The Supervisor doesn't always get to enter in the data, the week following the time card is completed, hence the need to enter in a date in the A2 cell