Calculate average speed
 

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

Calculate average speed
 

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

Calculate average speed
 

try this as inspiration:

http://pmexcelent.dk/Trainer.xls


"britgrit" skrev:

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

Calculate average speed
 

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

"Roger Govier" wrote:

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