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)).

 

[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