Hi my friend works for a Logistics company and is wondering how they can create

Question

Hi my friend works for a Logistics company and is wondering how they can create a template in excel to calculate Estimated time of arrivals based on miles per hour and distance
Please give me an example, my end goal is to create a template that can be used to plug in the miles per hour, the distance, also taking into consideration the number of stops during transit
Please provide a visual step by step example and step by step instructions on how to create on excel!
Scenario is road freight movement!

Explanation / Answer

1.open excel document

2. Write down employer name and all other necessary data

3.create a table with the following data

1.s.no 2 vehicle name 3.speed of the vehicle in miles per hour 4. Distance travelled by vehicle 5. time = distance/ speed

Then avg all those values in 5 column so that u can calculate estimated time of vehicles

That's it preparing for template

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.