Please help a rookie!

[Sami66]

I am only asking for help after Ive wracked my brain trying to figur
this one out.

I am doing a payroll spreadsheet with columns of "hours worked" an
"hourly payrate". I am now trying to do the formula for another column
"Gross Pay" How in the world do I take overtime in account in thi
column ALONG with 40 or less hours????

ANY help will be greatly appreciated!!!!

Sa

 

[Bob Phillips]

normal pay

=MIN(hours_worked,40)*rate

overtime

=MAX(hours_worked-40,0)*overtime_rate

--

HTH

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

 

[Sami66]

I need the gross pay, with or without overtime in the same column,
odnt have a seperate overtime column.

For example, D6= 40
D7=48

Column E is my payrate

Column F is where I want my gross pay to show

I realize Im babbling, but hopefully you know what I mean.

Thanks for responding!!!!

Please see my ediited pos

Attachment filename: project 3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61140

 

[Gord Dibben]

Sami

Try Chip Pearson's site for this subject.

http://www.cpearson.com/excel/overtime.htm

Gord Dibben Excel MVP

 

[Bob Phillips]

--

HTH

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

normal pay

=MIN(hours_worked,40)*rate

overtime

=MAX(hours_worked-40,0)*overtime_rate

--

HTH

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

 

[Bob Phillips]

So F simply is D7*E1 (or whichever row in E)

--

HTH

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