Time Calculations

I've uploaded an example of a time sheet I've created for my small business. I've figured out how to get the formulas working that calculate the number of hours a person has worked on any given day, but I'm having difficulty getting the column to total for the week's hours. (the cell that is highlighted in yellow)

I'd like to add together the values found in column G and display the findings in a format that indicates the number of hours and minutes worked per week. I'd also like to know if it's possible to set formulas in the blue shaded cells that will calculate the number of hours over 40 and display that in the same format.

Currently, I'm doing these calculations manually and it's taking too long.

Any help would be greatly appreciated.

V