Hi Myrna!
I've got to be perfectly honest with you and say that this
method makes absolutely no sense to me.(and I've been
doing this sort of thing for years). The formulas and the
math needed are easy but I'm having a hard time with the
logic.
I think your "delima" would be lessened considerably if
you used intermediate cells between weeks to calculate the
individual weekly totals.
How does this 1 day cell figure into the calculation of
OT?
If your employee works 40 hrs in both wk1 and wk2 and 8
hrs on this 1 extra day, is that 1 extra day OT?
If your employee works 44 in wk1 and 48 hrs in wk2 and 6
hrs on this 1 extra day, how is that paid?
I don't understand this 1 day cell!
Need a more detailed explanation.
Biff
-----Original Message-----
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
.
.