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