Question: Not quite understanding what to do for column E and F. Any help would be helpful Problem 3 (33 points) In this problem, you will

 Not quite understanding what to do for column E and F.

Not quite understanding what to do for column E and F. Any help would be helpful

Problem 3 (33 points) In this problem, you will learn how date/time data is stored in Excel by working with dates and times Lookup Reference Table Order Fulfill Time Bonus Order FlBonus Handled 2 Order ld 3 23-099 4 23-980 5 32-098 6 33-087 7 24-651 8 22-095 9 26-987 10 22-095 11 26-987 12 32-456 Time Recd 11/6/2018 11:00 Tim 11/10/2018 8:20 Jill 11/7/2018 9:05 Tim 11/9/2018 14:30 Tim ByTime Shipped (Hours) Amount 11/7/2018 14:30 27.5 11/13/2018 11:3575.25 Amount $1.25 15 $1.00 20 SO.75 30 $0.50 $0.25 50 S0.00 11/8/2018 11:45 11/12/2018 10:30 11/14/2018 9:45 11/14/2018 11:45 11/14/2018 16:45 11/15/2018 15:45 11/15/2018 14:45 11/16/2018 15:15 11/10/2018 13:30 Jill 11/11/2018 8:30 Jill 11/12/2018 8:30 Tim 11/13/2018 8:45 Jill 11/14/2018 9:50 Tim 11/15/2018 9:25 Jill Your task is to add formulas in columns E and F. Your formula in column E should calculate the total number of hours it took to fulfill the order, i.e the difference in time between order shipped and order recd (in hours). Your formula for column F should use the reference table to lookup (hint: VLOOKUP) the bonus amount for each order filled. The bonus amount depends upon the number of hours it took the order to get fulfilled

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!