Prepare a worksheet that allows the user to enter ONLY these fields:Start Timeand End Timeper day on a 5 day workweek (10cells)andHourly Wage (1 cell), Total HoursWorked(1cell), and Total Earnings (1 cell).So there should ONLY be 13data entry fields for the user. Each of those fields should have a title,so there should be an additional 13title cells explainingeach data cell.Make sure that the title fields are properly labeled. So, there should be 26 cells used in total.

The user will earn time and a half of the wage entered for the hours worked above 40 in a 5 day week.So if the user earned $10/hour and worked a total of 30 hours, the weekly earnings would be $300 (= $10/hours x 30 hours). However, if the user entered an amount over 40, the hourly wage for the overtime hours should be time and a half (which is 150%of the regular rate)calculatedat$10 x 1.5 = $15/hour. If the user worked 45 hours, the user would show earnings of $475(=(40 hours x $10/hour) + (5 hours x $15/hour)).

So

Your output cells should show:

1) the total amount hours worked and

2) the total weekly of earnings based uponthe start and end times from Monday through Friday and hourly rate.

The output for weekly earnings must use a single cell. All calculations MUST appear within that SINGLE output cell. You are not to add any more calculation cells than the ones described. You must use an IF function to calculate the output for weekly earnings.

Hint:

IF the worker entered 40 hours or less, calculate wages based on the regular pay rate only.

IF the worker entered more than 40 hours,there are 40 hours calculated at the regular rate PLUS the amount of hours above 40 at a rate 150% (or 1.5) times the regular rate.