I need help with the attached 3 sheets. The formula matching I need explained what and why would match each letter to each statement but does not have to be answered, I am more concerned with the formula sheets.
The other 2 sheets are formula related and I need those explained as to which formula to use and how.
Determine the AdjPay by computing the following bonus amounts.
(1) RushHour bonus is an extra $3.00 per hour for time spent driving during rush hour, from 2 PM til 6 PM.
(2) If Start Time is before 6 AM on Sunday or before 5 AM on Saturday, bonus is $30.
(3) If the average speed driven is 45 mph or less, bonus is $20. (Assume unloading at destination requires 30 Min.)
The expert examines excel formulas statements. The bonus amounts for AdjPay is determined.