Calculating Miles, Distance & MPH

**avidcat** · 07-07-2009, 04:44 PM

My wife wanted a excel sheet to track her walking. See Attached.

I think I have the time calculations wrong, for example I am entering 1.07 for an hour and 7 minutes.

I would appreciate someone taking a look at it and seeing if I have entered things correctly.

Thanks,
Nick

**daddylonglegs** · 07-07-2009, 04:51 PM

Hello Nick,

Excel works best with time if you input with a colon, e.g. for 1 hour 7 minutes use 1:07 and format column C as h:mm

That means a slight change to your column E formula, i.e. in E4 copied down

=IF(C4=0,"",D4/C4/24)

**avidcat** · 07-07-2009, 05:24 PM

Thanks daddylonglegs,

When I first entered time I was having trouble, but this:

=IF(C4=0,"",D4/C4/24)

is what I needed.

Thanks for your help.

Nick