S
sockmodel7
Alright, here's the deal, the wonderful people at my college bookstore
didn't manage to get my textbook in until 1 1/2 weeks left in the
semester and I need some help putting together a formula in Excel 2003
for the final that will determine the salary of multiple employees, at
different hours, pay per hour and overtime.
i.e.
employee 1: 40 hours at $9
emp. 2: 48 at 10
emp. 3: 42 at $8
emp. 4: 44 at $9.50
All hours after 40 hours are time and a half. If someone could help
construct a formula for this it would be hugely appreciated because my
efforts to do so have only resulted in profanity.
We'll also have to determine pay after 8% taxes, so I'm assuming that
can be done with a forumla sum=gross pay*8% followed by the auto sum
feature for all columns in that field?
didn't manage to get my textbook in until 1 1/2 weeks left in the
semester and I need some help putting together a formula in Excel 2003
for the final that will determine the salary of multiple employees, at
different hours, pay per hour and overtime.
i.e.
employee 1: 40 hours at $9
emp. 2: 48 at 10
emp. 3: 42 at $8
emp. 4: 44 at $9.50
All hours after 40 hours are time and a half. If someone could help
construct a formula for this it would be hugely appreciated because my
efforts to do so have only resulted in profanity.
We'll also have to determine pay after 8% taxes, so I'm assuming that
can be done with a forumla sum=gross pay*8% followed by the auto sum
feature for all columns in that field?