I have been tasked with coming up with an alternative to our current time card system and would like some input from those in the community.

Current System

Currently, our Payroll department prints out "time card sheets" from our HR/Finance software. It includes an employees information such as name, work calendar the employee is on, building, job description, month and year, and GL code.

The other thing it does is creates a table for each position so the employee can enter different hours for each position. The table has a column for each day of the week and a row for each week of the month. It also puts an X in days where there we are closed so the employee cannot enter anything by mistake on those days. (see attached time card)

Questions to Recreate

To recreate this, pulling the employee's information from the HR/Finance system is easy enough. So filling in the employee's name, building, calendar, position, building, etc. is not a problem.

The thing I cannot figure out is the best way to accomplish the table to record the hours. I can make the table, add column headers, and total rows and columns. But what would the best way to add a row for each week and putting an X in a day where we do not work?

Along with that, you will notice on the attached time sheet that an employee could have more than one position. A table needs to be created for each position.

Thank you in advance for your input.