Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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. 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 fulfilledStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started