overtime help with excel

"Calculating overtime" might be better. We are in an Excel forum after all, so that part is somewhat understood. Anyway..

In A5,

=IF(A4>9,A4-9,0)

Look in Excel Help for the IF function, as well as the millions of examples on the web.

There is nothing annoying about having a lack of knowledge, that's why there are forums such as this one. I see Paul's post as helpful to your cause and certainly not typographical sarcasm (although I don't know anyone's typographical intent) but that is just my take. Please remember that we all volunteer our time to help others who are having troubles with Excel.

Hi albertini

I thing you misunderstood the words of Paul and there is no reason to do it.

To certify as a (still) new to the Forum that all offer solutions with joy.

Paul is one of them personally I have watched him,many times to give excellent solutions.

Days of Christmas is, believe me, not worth worry about such things.

Now, for those who asked.

In A4, put the formula: =IF((($A$3-$A$1)-$A$2)>$IV$1;"";($A$3-$A$1)-$A$2)

In A5, put the formula: =IF((($A$3-$A$1)-$A$2)<=$IV$1;0;($A$3-$A$1)-$A$2)

Hope to helps you.

Merry Christmas!

Wouldn't 10 hours (9 @ $10.00 + 1 @ 15.00) = $105.00 (not $104.50)?

In A6 you would use:

=IF(A5>9,(A5-9)*15,0)

This says "If A5 is greater than 9, then multiply the number of hours greater than 9 by 15 (10 * 1.5). If A5 is not greater than 9, return 0."

See here for an assortment of user-created templates for payroll/time-keeping on microsoft's template download page: http://office.microsoft.com/en-us/te...010117277.aspx

In A6 do you just want overtime pay calculated, or regular pay + overtime pay? I already showed you the overtime pay, so if you want it to show the total combined you could use:

=A5*10+IF(A5>9,(A5-9)*5,0)

This says "Multiply A5 by 10. If A5 is greater than 9, find out how many hours over 9, multiply that by 5, then add it to the previous total."

It's not multiplied by 15 because we already multiplied all hours by 10, not just the standard time hours. It could be done separately which might be a bit more readable, e.g.

=IF(A5>9,(A5-9)*15+90,A5*10)

This is "If A5 is greater than 9, add 90 to the number of overtime hours multiplied by 15. If not, simply multiply A5 by 10 to get standard pay."

There are no Excel universities that I know of. I started here several years ago and knew enough to be useful. After years of reading and responding to posts I now know far more than I did back then. Like all things, though, you need to keep using it to retain the knowledge and (hopefully) improve.

The best way to learn about Excel is to keep working with it and frequenting Excel forums when you don't understand something. People do earn good money and notch out a career by presenting Excel workbooks that produce valuable results for the end users.

Sorry to see that albertini, hopefully you can bounce back soon.