Kilometres Calculator

S

Steved

Hello from Steved

I would like a formula to calculate the time it takes to travel 10
kilometres driving at 28 kilometres per hour.

Thankyou.
 
J

JE McGimpsey

One way:

Times are stored in XL as fractional days, so if you want to return XL
times, divide the result by 24:

=10/28/24 ===> 0:21:26

and format as a time. Or, if you want to use cell references.

A1: 10
B1: 28
C1: =A1/B1/24 ===> 0:21:26

Alternatively, if you want your result in minutes rather than an XL time:

C1: =A1/B1*60 ===> 21.42857


Format In article <[email protected]>,
 
D

David Billigmeier

You wouldn't need an excel function to do that, the number of hours is 10/28.
Is there something else you needed that I didn't understand?
 
S

Steved

Hello JE from Steved

using your example 0:21:26 can I have it showing 21 (Rounding up or down)

Thankyou
 
J

JE McGimpsey

Use the last example I gave you - either format it to display no decimal
places, or use

=ROUND(A1/B1*60,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top