Time card workbook @ pivot tables - best way

What I need is relatively simple, or so I thought. I have employee names in one column and across the top are the dates of the week and hours are put under each employee for each day. A calculation is at the end calculating the total hours and then the summary has their rate multiplied for the gross pay. The way it is now, it seems about impossible to try and create a pivot table from that, at least on an ongoing basis.

I was pondering whether this should be done in Access vs Excel. I have exhausted searches on the internet trying to help me with what I am trying to do.



I have attached a copy of the workbook we are currently using so you can get a better idea of what I am trying to do.


Any help would be greatly appreciated. Thank you.

**I would like to mention I have made many other posts on this topic this morning so here are the links:
http://www.ozgrid.com/forum/showthre...461#post599461
http://www.vbaexpress.com/forum/showthread.php?t=9305
http://www.excelkey.com/forum/viewto...8&p=2854#p2854

I thought I posted on Windowssecrets.com but cant find anything, I might have just been doing some searching.
I might have missed a post somewhere along the way, if so it is not intentional. These are the only windows I had left open in order to check.