EXcel Formula

  ukhomerj2003 11:10 03 Nov 07

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 07

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 07

Maybe =A/B

  The F1 Help Key 13:01 03 Nov 07

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

  daba 13:23 03 Nov 07

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 07


That was spot on

Thank you very much

  daba 13:53 03 Nov 07

no probs

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

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

1995-2015: How technology has changed the world in 20 years

This animated short film tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…