sockmodel7
New Member
- Joined
- Dec 5, 2005
- Messages
- 5
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?
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?