Hi

Excel store times as fractions of a day, so multiplying by 24 gives a
decimal value to dived into the mileage.
Try
=D1/(E1*24)
Format the cell as Number or General


--
Regards

Roger Govier


"britgrit" wrote in message
...
I have a training spreadsheet which includes distance in miles xx.xx
(column
D) and lapsed time in h:mm:ss (column E)
How do you enter and format the lapsed time data so excel can
calculate the
average speed (column F)?
I've tried [h]:mm:ss and this doesn't seem to work (and about 20 other
permutations from the online "help") :-(