ExcelBanter - Calculating speed

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Calculating speed (https://www.excelbanter.com/excel-programming/396058-calculating-speed.html)

Robbie1299

Calculating speed

I run a mile in 8:40 (I5) in [m]:ss format

How do I calculate my speed?

JockW

Calculating speed

Try this:

distance/(time[hh:mm:ss]*24)
Format the formula cell as number
--
hth

"Robbie1299" wrote:

I run a mile in 8:40 (I5) in [m]:ss format

How do I calculate my speed?

All times are GMT +1. The time now is 12:23 AM.