calculateing MIN,MAX cells for purpose of payroll

[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

 

[Rob]

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)

 

[Bob Phillips]

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)

 

[pfsardella]

Here are three links that deal with TimeSheets. Chip Pearson's has
some good examples. John Walkenbach's has a download. David Mcritchie
has a lot of good background.

http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/overtime.htm
http://j-walk.com/ss/excel/files/timesht.htm

HTH
Paul