EXCEL TUTORIAL - creating a pace / speed athletics spreadsheet using FLASH FILL

[@mateuswitiski5263]

Thanks for this. Way more useful than most running log sheets out there

[@Lumencraft-]

Best excel tutorial ever!! Thank you.

[@benjohnston7742]

Your a hero the fraction of a day thing saved hours of work

[@upward-trend]

Great info thanks. I did not know about flash fill. Another and easier way to get average speed is to directly convert pace to speed. To do this insert the formula =1/(H2*24) into cell I2

[@timwilson1974]

Thanks for this Ben - Very helpful at getting to the point and providing the solution.

[@prvdev]

not all heroes wear capes

[@mattdriver9763]

This was really helpful, how would you then plot the pace on a graph?

[@BrahimBessrour]

Thanks for sharing

[@8strings]

Thank you very much Ben. You are a genius.

[@averagenorserunner2907]

Very helpful, and well explained. Thanks!

[@allanpark6046]

Excellent. Thank you.

[@earlymorningproductions9355]

Brilliant! Thank you!

[@marcelvannieuwenhuizen5828]

Hi Can I ask, I want you use min, sec and milliseconds, how can I do this?

[@benaryder]

At 0:55 when you format the time cell, use the format mm:ss.000 (if you truly do want milliseconds. For centiseconds, you'd use mm:ss.00)

[@marcelvannieuwenhuizen5828]

@@benaryder Hi Ben Thank you for replying. After some playing around and reading post I eventually got to that conclusion, only to run into another. I am using excel and looking at the following problem as soon as I enter my mm:ss,000 it shows the rounded of sec in the formula bar, as soos as I try to correct it or press enter the rounded of sec are used and I loose my real millisecond value. It seams like many people have experienced it before.

[@CuteNoririn]

This is awesome, it works! thank you!

[@martinvalach7550]

Thanks!

[@heeravishwanath6339]

Can you please share the sample Excel file?

[@manonvito7020]

thank you

[@jamesbcd]

Helpful thanks