velocity=Distance/time

[Rasoul Khoshravan Azar]

I want to obtain velocity of a vehicle by dividing distance(ordinary number
format) to time(time format of 00:00) by the formula: velocity=distance
(km)/Time(minute). And alternatively transfer it to Km/hour unit.
Divding numbers by 00:00 format requires special command which I have
forgotten.
Any help or sugesstion will be highly appreciated.
TIA Rasoul Khoshravan Azar

[Dave Peterson]

With the km in A1, the time in B1:

=A1/B1/24

But format that cell as General (or some Number (not Time)).

Rasoul Khoshravan Azar wrote:
>
> I want to obtain velocity of a vehicle by dividing distance(ordinary number
> format) to time(time format of 00:00) by the formula: velocity=distance
> (km)/Time(minute). And alternatively transfer it to Km/hour unit.
> Divding numbers by 00:00 format requires special command which I have
> forgotten.
> Any help or sugesstion will be highly appreciated.
> TIA Rasoul Khoshravan Azar

--

Dave Peterson

[Bernard Liengme]

A1=distance (say 25)
B1= time (say 0:30)
C1= A1/(B1*24) you may need to format cell as general or number (example
will show 50)

Time is stored as fraction of a day hence the need to multiply by 24.
best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Rasoul Khoshravan Azar" <rasoulazar@hotmail.com> wrote in message
news:u9Z46ZZBFHA.1260@TK2MSFTNGP12.phx.gbl...
>I want to obtain velocity of a vehicle by dividing distance(ordinary number
> format) to time(time format of 00:00) by the formula: velocity=distance
> (km)/Time(minute). And alternatively transfer it to Km/hour unit.
> Divding numbers by 00:00 format requires special command which I have
> forgotten.
> Any help or sugesstion will be highly appreciated.
> TIA Rasoul Khoshravan Azar
>

[Rasoul Khoshravan Azar]

Dear Dave
Thanks that worked and give the result as Km/hour.
If I want to get the result in Km/minute, I can divide the result to 60.

"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:41FAD819.3ACC425E@netscapeXSPAM.com...
> With the km in A1, the time in B1:
>
> =A1/B1/24
>
> But format that cell as General (or some Number (not Time)).
>
> Rasoul Khoshravan Azar wrote:
> >
> > I want to obtain velocity of a vehicle by dividing distance(ordinary
number
> > format) to time(time format of 00:00) by the formula: velocity=distance
> > (km)/Time(minute). And alternatively transfer it to Km/hour unit.
> > Divding numbers by 00:00 format requires special command which I have
> > forgotten.
> > Any help or sugesstion will be highly appreciated.
> > TIA Rasoul Khoshravan Azar
>
> --
>
> Dave Peterson