formulas

E

Earl A

How do i write formul for hours over 40, anything over 40 is Overtime. I
can not find the formul to seperate reg time from overtime. Can some one help
me?
 
E

Elkar

Let's say your total hours are in cell A1. Use these formulas:

Regular Hours:
=MIN(A1,40)

Overtime Hours:
=MAX(A1-40,0)

HTH,
Elkar
 
G

Gary''s Student

Let's put total hours in A1. Assume that straight time is $12.00 per hour
and overtime is $18.00 per hour

=IF((A1<=40),A1*12,480+(A1-40)*18)
 
E

Earl A

Elkar, it worked for the overtime but it still total #of in hours in my reg
time. h21 shows my total hours of 67. I need to show 40 in reg time & 27 in
overtime. overtime is in i21. THANK YOU VERY, VERY MUCH. ELKAR I AM NOT SURE
OF WHAT I AM DOING WRONG.
 
F

Fred Smith

Go back and check what you entered, because Elkar's formulas are correct.
Without knowing exactly what you entered, it's not possible to tell you what you
are doing wrong.

If h21 has your total hours (67) in your case,

Reg hours: =min(h21,40)
Overtime hours (i21): =max(h21-40,0)
 
Top