Calculating time for certain distance and speed?

**soreno** · 03-26-2010, 07:11 AM

Hello!

If I have speedvalue in cell A1 let say 100 km/h and I put the distance in cell A2.

How would the formula look like in A3 to see the time it takes to drive this distance?

Example
A1 = 100 km/h
A2 = 750 meters
A3 = time to travel the distance

**StephenR** · 03-26-2010, 07:43 AM

Speed=distance/time so time=distance/speed. Remember to keep units consistent.

Time=(A2/1000)/A1

**soreno** · 03-26-2010, 08:12 AM

Originally Posted by StephenR

Speed=distance/time so time=distance/speed. Remember to keep units consistent.

Time=(A2/1000)/A1

Hmm..

If I simplify a little by using below numbers and your suggested calculation

A1 = 100 km/h (speed)
A2 = 50 000 meters (distance)
A3 {=A2/1000)/A1] Results in "0,50"

It should give me 30 minutes or 1800 seconds but it does not work with any time formula on the A3 cell

Thanks