Transportation need to evaluate the time spent in traveling from city A to city B. The distance between the two cities is a variable because the macro developed is to be used for other cities. 50% of travel time is done at a speed of 30 miles an hour and the remaining 50% of the travel time is done at a speed of 65 miles per hour. Write an macro that will take the distance between two cities from a worksheet and calculate and display the time it will take to travel from one city to the next.