Kilometres Calculator

[Guest]

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.

 

[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]>,

 

[Guest]

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?

 

[Guest]

Hello JE from Steved

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

Thankyou

 

[JE McGimpsey]

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

=ROUND(A1/B1*60,0)

 

[Guest]

Thankyou JE

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

=ROUND(A1/B1*60,0)