got automatic timesheets working and summary of hours working.

Should be good to go but just following the procedure.
Ok I understand how this works now just a couple of notes. This is not how our DB schema described it so that is not how I set up my queries. If this is the way we are doing it the type:1/2 fields are not necessary. In their place you should put the rowId?