Figureing Running Speed in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to figure my running speed in excel for my own use, this is what I am trying to do.

A1 = My running time, don't know if this can be h:m:s, or just has to be in minutes.
B1 = Number of miles that I ran today.
C1 = MPH, (My running speed for that day)

Can someone help me out?

Thanks!
 
One approach is to enter your time in hours:minutes:seconds in A1 like:
0:34:12. You might use the Time format (Format, Cells) that appears as
"13:30:55" in the number format dialog. You always have to enter the hours,
even if 0.

Then with the miles in B1 this formula in C1 returns your speed in MPH:
=(1/24)/A1*B1. Give this cell a number format if Excel automatically
applies a Time format.
 
Back
Top