Calculating Speed

[Liverpool1959]

Hello. I am looking for a formula to calculate how far you travel in ONE SECOND at both 40 KPH and 60 KPH. Yes Kilometers Per Hour. I am in Canada!!

 

[offthelip]

Assuming you want the answer in metres:

=40*1000/(60*60)

for 40 Kph
change the 40 to 60 for 60 kph, or put it in cell and change the cell

 

[Repush]

k is for kilo
K is for Kelvin

even in Canada

 

[Eric W]

There's a CONVERT function too:

=CONVERT(40,"km/hr","m/sec")