Explore BrainMass

# Overtime Excel

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Overtime

You run a company with 6 employees. Create a spreadsheet that keeps track of the hours each employee works and determines their weekly salary. If they work 40 hours or less, they simply get their hourly wage times the number of hours worked. If they work overtime, anything over 40 hours gets paid time and a half; so 2 overtime hours gets paid for 3 hours worked.

a.) Compute the hours worked for the week for each employee.

b.) Enter a formula which computes the hours worked over 40 for each employee. If they worked no more than 40 hours, this formula should return 0.

c.) Enter a formula which computes the total weekly wage for the employees. The formula should give time and a half for any hours worked over 40. Format as currency to 2 decimal places.

Activity Description:
In this problem, you will calculate the total hours each employee worked and determine their weekly salary.

Steps to Perform:
1 Start Excel. Download and open the workbook named: Activity 3 Overtime

2 In cell I12, calculate the hours worked for the week by Jill Ackers. Fill cell I12 down the column to cell I17.

3 In cell I21, use the IF function to determine the hours worked over 40 by Jill Ackers. If the employee worked no more than 40 hours, the formula should return 0. Fill cell I21 down the column to cell I26.

4 In cell I30, use the IF function to calculate the total weekly wage for Jill Ackers. Fill cell I30 down the column to cell I35. Format cells I30:I35 as Currency with 2 decimal places.
Note: The formula should give time and a half for any hours worked over 40.