I have 5 employees.
How would you write this formula to calculate time and 1/2 over 40 hrs. in a
single week if even over 40hrs for the week and then calcuate the same for
the second week then figure the single day also.

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.
Myrna
--
Thank you

Hi Myrna!

It depends on how you pay overtime and what you mean
by "then figure the single day also".

Do you pay OT only after an employee has worked 40 hrs?
Or, do you pay OT after an employee has worked 8 hrs a day?
What if an employee works 12 hrs on Monday and then calls
off on Tuesday?

You say that P5 is a single day. I have no idea what that
means.

Your basic setup should include a cell to calculate
regular hours and then another cell should calculate OT
hours.

Biff

-----Original Message-----
I have 5 employees.
How would you write this formula to calculate time and
1/2 over 40 hrs. in a
single week if even over 40hrs for the week and then
calcuate the same for
the second week then figure the single day also.

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.
Myrna
--
Thank you
.

Biff,
My table includes a row from B5 through P5.
This is 15 days or cells.
I pay overtime within a calendar week of Mon through Sun only (7 days).
If they exceed 40 hours within 7 cells of the 15 cells.
How do I calculate the formula for the whole 15 arrangement.

"Biff" wrote:

Hi Myrna!

It depends on how you pay overtime and what you mean
by "then figure the single day also".

Do you pay OT only after an employee has worked 40 hrs?
Or, do you pay OT after an employee has worked 8 hrs a day?
What if an employee works 12 hrs on Monday and then calls
off on Tuesday?

You say that P5 is a single day. I have no idea what that
means.

Your basic setup should include a cell to calculate
regular hours and then another cell should calculate OT
hours.

Biff

-----Original Message-----
I have 5 employees.
How would you write this formula to calculate time and
1/2 over 40 hrs. in a
single week if even over 40hrs for the week and then
calcuate the same for
the second week then figure the single day also.

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.
Myrna
--
Thank you
.

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...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=276115

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...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=276115

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


.

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


.