Time Card Formula Help

[gdillon]

On the time card below, I need a way to calculate Regular time and/or Overtime. Overtime only kicks in after 40 hours, right now you will see the time card doesn't separate the regular time to overtime. What is the best way to calculate Overtime and separate it not only on a total week but also show it on the days that OT is present? You see line 16 it has cells marked Reg and OT for this, I just need the solution to make it happen.
Thank you in advance

Weekly time sheet with breaks1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
8
9				Sunday		Monday		Tuesday		Wednesday		Thursday		Friday		Saturday
10				5/29/2005		5/30/2005		5/31/2005		6/1/2005		6/2/2005		6/3/2005		6/4/2005
11		TimeIn		6:00AM	Total	6:00AM	Total	6:00AM	Total	6:00AM	Total	6:00AM	Total	6:00AM	Total	6:00AM	Total
12		TimeOut		12:00PM	6.00	12:00PM	6.00	12:00PM	6.00	12:00PM	6.00	12:00PM	6.00	12:00PM	6.00	12:00PM	6.00
13			MealBreak
14		TimeIn		1:00PM	Total	1:00PM	Total	1:00PM	Total	1:00PM	Total	1:00PM	Total	1:00PM	Total	1:00PM	Total	RegHours	OTHours
15		TimeOut		5:00PM	4.00	5:00PM	4.00	5:00PM	4.00	5:00PM	4.00	5:00PM	4.00	5:00PM	4.00	5:00PM	4.00
16				Reg	OT	Reg	OT	Reg	OT	Reg	OT	Reg	OT	Reg	OT	Reg	OT
17		Total		10.00		10.00		10.00		10.00		10.00		10.00		10.00		70.00	0.00
Weekly Time Sheet

 

[barry houdini]

At what point does regular time become overtime?

Assuming anything above 8 hours is overtime on a Monday try, in G17

=MIN(8,H12+H15)

and in H17

=H12+H15-G17

 

[gdillon]

Time Card Help

Overtime starts after 40 hours, So I need to have a formula that will separate the Regular time and Over Time when it reaches the threshold of over 40 hours in a week. But need to show breakdown of Regular Time and Overtime per day.