Kilometres Calculator
 

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.

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 ,
Steved wrote:

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.

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?

--
Regards,

David Billigmeier



"Steved" wrote:

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.

Hello JE from Steved

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

Thankyou

"JE McGimpsey" wrote:

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 ,
Steved wrote:

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.

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

=ROUND(A1/B1*60,0)

In article ,
Steved wrote:

Hello JE from Steved

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

Thankyou

"JE McGimpsey" wrote:

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 ,
Steved wrote:

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.

Thankyou JE

"JE McGimpsey" wrote:

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

=ROUND(A1/B1*60,0)

In article ,
Steved wrote:

Hello JE from Steved

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

Thankyou

"JE McGimpsey" wrote:

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 ,
Steved wrote:

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.