excel

Excel 11 - Overtime

Q Reasoning Company
Employee		Daily Hours Worked
Last	First	Mon	Tue	Wed	Thu	Fri	Hourly Wage	Total Hours
Ackers	Jill	4	4	4	4	4	$ 12.50
Bartel	Channing	11	10	4	5	10	$ 10.00
First	Last	9	7.5	6.5	7	13	$ 10.00
Hill	Jonah	2	1	0	1.5	0.1	$ 2.25
Jackson	Five	12	8	14	22	16	$ 45.00
Yu	Tu	5	8	7	8	7	$ 150.00
						Last	First	Hours Over 40
						Ackers	Jill
						Bartel	Channing
						First	Last
						Hill	Jonah
						Jackson	Five
						Yu	Tu
						Last	First	Weekly Salary
						Ackers	Jill
						Bartel	Channing
						First	Last
						Hill	Jonah
						Jackson	Five
						Yu	Tu

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 less than 40 hours this formula should return 0. Use Excel's IF function.

c.) Enter a formula which computes the total weekly wage for the employees. The formula should give time and half for any hours worked over 40. Format as currency. Use Excel's IF function.