need help finding formulas for overtime and absence to compute in excel please

Pay This assignment will examine the use of the logical, lookup and flash fill functions that we talked about Problem 1) Create a new worksheet and name it Problem 1. Enter the following information: A B E F 1 Payroll Report Hourly 2 Employee Hours Wage Overtime? Absence? 3 Adams 28.00 11.50 4 Barkley 32.00 13.75 5 Billings 40.00 21.95 6 Davis 41.00 18.77 7 Dorring 39.75 15.44 8 Edwards 42.25 16.32 9 Fredricks 43.00 12.45 10 Harris 42.50 10.51 11 Jones 55.00 8.75 12 Jones 40.00 18.72 13 Lewis 40.00 23.50 14 Ocampo 40.00 21.22 15 Smith 40.25 19.74 16 Williams 47.00 19.75 17 18 Average 19 Total In column D, you are to create a formula that will determine a person's earnings. If the person had 40 or less hours, his/her pay is calculated by simply multiplying the hours the person worked by the hourly wage value. If the person worked more than 40 hours, then the pay is calculated using the following formula ((Hours - 40) * 1.5 Hourly Wage) + (40 Hourly Wage). This will correctly pay time-and-a-half for any hours worked about 40 hours. In column E, you are to create a formula that will output "Yes" if the person received overtime pay or "No" if he/she did not In column F, you are to create a formula that will output "Yes" if the person was absent during this pay period. You can determine this by looking to see if a full 40 hour work week was put in