how to calculate travel times ie 72km at 80kmh

M

Mark Lewis

I am doing a travel itinery with start and finish points...I can estimate my
average speed between these two points (and I know the distance), but my
limited math skills prevent me from expressing the answer in time (be it
minutes or hour and minutes)...this answer is then added to my start time and
so on.
I need help in devising a formula
 
P

Pete

As speed = distance / time, so time = distance / speed. So if you have
your distance in A1 (say) and average speed in B1, then in C1 you can
enter the formula:

=A1/B1

This will give time in hours if distance is in km and speed is km/hr.
If you want the time in minutes, multiply by 60. If you want cumulative
time in column D, enter this formula in D2:

=C2 + C1

Copy both formulae down the columns for the extent of your itinery.

Hope this helps.

Pete
 
P

Pete

Sorry, the second formula should be:

=C2 + D1,

and in D1 you should enter:

=C1

Hope this helps further.

Pete
 
M

Mark Lewis

Thankyou Pete...you are a legend...really appreciate your prompt reply..now I
need to express the answer in hr:m format...how do I do that? My email
address is mark.lewis@virtual should you wish to send me a sample
spreadsheet...if you have the time.
 
P

Pete

Hi Mark,

change the formulae to:

=C1/24 in cell D1, and:
=C2/24+D1 in cell D2.

Format both cells using Custom and set to [h]:mm. Copy D2 down column D
as necessary.

Hope this helps - no need for a sample, I think.

Pete
 
Top