Calculate Regular Hours then Overtime

[MrFlyer]

Good Afternoon Everyone,
I am currently working on a time sheet to track an employee's time per each day of the month. I am currently stuck on figuring out how to calculate the regular hours for the week then the Overtime for the week. Example employee works 8.5 hrs on monday, 8 hrs on tuesday through thursday and 5 hrs on friday. i would like it to show 37.5 hours for the Total Regular hrs and 0 for Total Overtime. Every attempt I have done ends up in a circular reference. Is there a way to work around the Circular reference or am i stuck with the circular reference?

Time Sheet Example.xlsx
	A	B	C	D	E	F	G	H
1	Day of Week	Time In	Lunch Out	Lunch In	Time Out	Out of Office	In Office Hrs	Overtime Hours
2	Mon	7:00 AM			3:30 PM		8.00	0.50
3	Tue	7:00 AM			3:00 PM		8.00	0.00
4	Wed	7:00 AM			3:00 PM		8.00	0.00
5	Thu	7:00 AM			3:00 PM		8.00	0.00
6	Fri	7:00 AM			12:00 PM		5.00	0.00
7	Week 1 Total:						37.00	0.50
Sheet1

Cell Formulas
Range	Formula
G2:G6	G2	=IF((((C2-B2)+(E2-D2-F2))*24)>8,8,((C2-B2)+(E2-D2-F2))*24)
H2:H6	H2	=IF(((C2-B2)+(E2-D2-F2))*24>8, ((C2-B2)+(E2-D2))*24-8,0)
G7:H7	G7	=SUM(G2:G6)

 

[arc6th]

OT hours by day is tough. All OT hours are, technically, the last hours worked in the week.

This formula would show OT hours by day after 40 have been worked, (H2 would not need a formula because it's impossible to work 40 hours on the first day.)
H3: =IF(SUM(G$2:G3)>40,SUM(G$2:G3)-40-SUM(H$2:H2),0) [drag it down]

If the OT Hours column for each day must be maintained I'd make it a Variance column simply showing +/- compared to an 8 hour day. The sum for the column would display either 0 or a positive number.

 

[MrFlyer]

OT hours by day is tough. All OT hours are, technically, the last hours worked in the week.

This formula would show OT hours by day after 40 have been worked, (H2 would not need a formula because it's impossible to work 40 hours on the first day.)
H3: =IF(SUM(G$2:G3)>40,SUM(G$2:G3)-40-SUM(H$2:H2),0) [drag it down]

If the OT Hours column for each day must be maintained I'd make it a Variance column simply showing +/- compared to an 8 hour day. The sum for the column would display either 0 or a positive number.

It is mainly the Total I'm concerned with because I agree per day is difficult.