Calculating Paycheck with Overtime.

  • Thread starter Thread starter Paxton
  • Start date Start date
P

Paxton

I'd like to figure out how to set up my spreadsheet to calculat
overtime if need be.

I have been putting my work hours in excel 2003 and I can't figure ou
how to take the difference from 40hrs, multiply that x by (my wages
1.5) then add that back to my original 40 hr total?

Here's a pic of my Spreadsheet:

http://tinyurl.com/ytfrp


Any suggestions?
Thank you for reading, I appreciate your feedback.

If you're not registered with yahoo photos I don't know if you can se
it.
Basically I have:
my wages in c5

Thanks again.
tax, .825, in c6
total work hours for week 1 in g5
and my total net pay in g
 
Hi Paxton!

I'm assuming that your calculations are in Excel time format

Try:
=(MIN(A1,"40:00:00")*24*30)+(MAX(0,A1-"40:00:00")*24*30*1.5)

I've used a wage rate of 30.

=MIN(A1,"40:00:00")*24*30
Returns 30 per hour on the hours worked subject to a maximum of 40
hours

=MAX(0,A1-"40:00:00")*24*30*1.5
Returns 30 per hour *1.5 on the excess of hours (if any) over 40
hours.


If your calculations are in decimal hours use:

=(MIN(A1,40)*30)+(MAX(0,A1-40)*30*1.5)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top