Calculate average speed

[Guest]

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") :-(

 

[Roger Govier]

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

 

[Guest]

try this as inspiration:

http://pmexcelent.dk/Trainer.xls


"britgrit" skrev:

 

[Guest]

Many thanks! - It's so easy when you know how isn't it?

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

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") :-(