calculating average speed

Bernard Desrochers · Nov 7, 2004

trying to calculate average speed as below.

cell A4 : Kilometer
145

cell B4 : time
3:45:23

need average speed in C4

tks

[email protected]

Frank Kabel · Nov 7, 2004

Hi
=A4/(B4*24)
and format as number