EXcel Formula

  ukhomerj2003 11:10 03 Nov 2007

I am trying to create a training diary for my cycling activity using Excel. I have two columns containing data for distance in Kms and time in HH:MM format. How can i create an average spped in a third cell from these two pieces of data.

  johnnyrocker 11:45 03 Nov 2007

try the ' formulae' like a divided by b = av speed sorry i have forgotten the symbols but i am sure i am on the right track.


  Sea Urchin 12:34 03 Nov 2007

Maybe =A/B

  The F1 Help Key 13:01 03 Nov 2007

=averaeg ...selecting the both two sum columns..happycomputer

  daba 13:23 03 Nov 2007

Column A, Distance in Kilometres

Column B, Time in Hours and minutes (Format Cells as "Custom" format hh:mm)

Column C, enter formula "=(A1/B1)/24" - change the row number to top row of your data, I don't know what headings you have)

Copy Column C cells down as required.

The result in C will be the average speed for each trip.

  ukhomerj2003 13:41 03 Nov 2007


That was spot on

Thank you very much

  daba 13:53 03 Nov 2007

no probs

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Illustrator Sylvain Tegroeg created thousands of intricate line drawings for the mobile game…

Best iPad buying guide 2017

Comment télécharger une application indisponible en France ?