I need a formula to start with a time, 10:00 pm and based on the event in Column A, event 1,2 or 3, reference the chart to the right and add the time to complete the event.
Event Start Time Est Time Event # Event Distance Est Time minutes
3 10:00 PM 1 Swim .24 miles 0:10 minutes
3 10:00 PM 2 Bike 11.48 miles 0:50 minutes
2 PM 3 Run 2 miles 0:16 minutes
3 PM
3 PM
2 PM
3 PM
3 PM
2 PM
Solved by G. B. in 30 mins