This is how I would do it.

First I still wouldn't bother with Access.

Second, I would create a template timesheet, and add worbook sheet change event to handle time input of format 3.5.

Third, I would create a master data workbook with three sheets, the first with the employee names, other data you want about them, and a second for the timesheet data, and a third for a pivot analysis.

Fourth I would create an addin that created its own custom menu with the following functions,
- create a new workbook with a timesheet worksheet for each current employee
- consolidate the timesheet data into the master data workbook
- view the pivot table
- any other niceties you may want.

I wouldn't use Access as I feel that there is a ton of native Excel functionality that you could tap in this application. I m ight consider using Access as purely a database (none of its form functionality) in place of the master data workbook, using ADO to update it, and generate the pivot table dynamically from that, but probably not. The data wouldn't warrant it.