Bob;

It does, and thank you very much

--

Regards
Michael Koerner


"Bob Phillips" wrote in message
...
=N(A2/(B2*24))

where A2 is the distance, B2 the time.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Michael Koerner" wrote in message
...
I have sheet with columns listed as distance and time. An example of the
values in these columns are distance 5.0 km and the time column is
00:52:30.15 what type of formula would I would I need for a value in a
kilometre per hour column. TIA

--

Regards
Michael Koerner