Biff,
This worked great but my delima is.

B5 to H5 = 7 days
I5 to O5 = 7 days
S5 = 1 day
T5 is hourly rate $8

If my worker works 49 hours the first 7 days. He will be paid overtime
for this.
If my worker works 15 hours the 2nd 7 days. There is no overtime
And the final day 1 hour. There is no overtime.

Notice the total hours add up to 65 hours. I made a mistake on how to
reference the delima in my last post.

Need to calculate the formula in a different way.

"Biff" wrote:

Hi!

Try this:

=IF(S580,(S5-80)*A1*1.5+80*A1,S5*A1)

Biff

-----Original Message-----
Duane,
I inserted this formula T5 cell.
Made A1 = 8
So I inserted 6 into B5 all the way to P5.
The formula is giving me a different figure than I
should have.
Myrna


"duane" wrote:


something like

assuming a1 = hourly rate=8/hr

t5=sum(b5:h5)*a1+if(sum(b5:h5)40,sum(b5:h5)-40,0)
*a1*1.5+
sum(i5:o5)*a1+if(sum(i5:o5)40,sum(i5:o5)-40,0)*a1*1.5+
p5*a1

B5 to H5 is 1 week, I5 to O5 is 2nd week, P5 is a
single day. S5 =
total
hours. T5 is Gross Pay = total hours x 8 an hr


--
duane


--------------------------------------------------------
----------------
duane's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=11624
View this thread:
http://www.excelforum.com/showthread...hreadid=276115


.