calculateing MIN,MAX cells for purpose of payroll

  • Thread starter Thread starter Thaddeus
  • Start date Start date
T

Thaddeus

I can not seem to find the formula to calculate my own
payroll sheet.
EX: total hours for one week are 65.50 entered in mon-
sunday columes for each day, sum'd in one cell.

I would like to assign a cell to multiply reg hours, max
40 by one rate(and not to exceed 40),place the sum in a
designated cell, then multiply the balance (in this case,
25.50 hours(65.50-40.00)) by a second and different rate
and placed in another designated cell.

can you please help??

Thank you, Thaddeus
 
If I've understood correctly, you could use the following
formula, F3 contains the total hours, C3 is the rate for
40 hours or below, C4 is the rate for hours above 40.

Pls come back if this isn't what you want.

Rob



=IF(F3>40,(40*C3)+((F3-40)*C4),F3*C3)
 
Thaddeus,

Assuming the total in H2, the normal rate in K2, overtime rate in L2, uses
these formulae

Normal time: =MIN(40,H2)*K2
Overtime: =MAX(H2-40,0)*L2

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top