Hi beardking,
I'm sorry that I can't help you with the formulas, but I can recommend you a good working hours timesheet for 5 days.
http://spreadsheetzone.com/templateview.aspx?i=109
It can give an idea on how to create your own spreadsheet, I suppose.
Suzzy