Formula for Kilometers to time Please

[Steved]

Hello from Steved

Travelling at 28 Kilometres per hour

Kilometres travelled is 7.6

What is the formula to tell me how long did it take.

Thankyou.

 

[Bob Phillips]

=A25/28 if you want decimal time

=A25/28/24 if you want the answer in time format (you will need to format
the cell)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Steved]

Thanks.

-----Original Message-----
=A25/28 if you want decimal time

=A25/28/24 if you want the answer in time format (you will need to format
the cell)

--

HTH

RP
(remove nothere from the email address if mailing direct)





.