Timecard Condition Formula?

[iexcel]

Hi all, I need a formula for the following conditions: I’m doing a timecard. Our regular total hours per day is 7:30 hours. So if you worked 8 hours, you get 7:30 regular hours in cell F6, 0:30 minutes regular rate overtime in cell G6. Lets say you worked 9 hours, you get 7:30 regular hours in cell F6, 0:30 minutes regular rate overtime in cell G6, 1:00 hour time and half overtime in cell H6. This is where I can't figure out, when cell G6 automatically fills in the 0:30 minutes regular rate overtime when you worked more than 8 hours. Please help. Thank You Very Much. John.

 

[fairwinds]

Hi,

Try this:

Book1
	E	F	G	H	I
5	Totalh	Regular	RegularOT	ExtraOT
6	09:00	07:30	00:30	01:00
7
8
Sheet1

 

[iexcel]

Thank you for responding, This formula works when someone works over 8 hours. With this formula and a combination of another,what if someones works under 7:30 hours a day,cell E6, Cell G6 should be 0:00. Please help.
Thank You, John

 

[Chitosunday]

cell g6 formula =MIN("0:30",MAX(0,E6-F6))
cell h6 formula =MAX(0,E6-F6-G6)

 

[fairwinds]

Hi,

I think they work as advertised, please try again.

Chito: I added your formulas below, they work too but I fail to see any improvement.

03_23.xls
	E	F	G	H
5	Totalh	Regular	RegularOT	ExtraOT
6	03:50	03:50	00:00	00:00
7
8			00:00	00:00
Sheet2

 

[Chitosunday]

Fairwind, I check your formula and you are right. Your original formula is correct. Sorry, I didn't test it before as the OP immediately replied there is something wrong on values less than 7:30.