# Calculating Miles, Distance & MPH

1. ## Calculating Miles, Distance & MPH

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

2. ## Re: Calculating Miles, Distance & MPH

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)

3. ## Re: Calculating Miles, Distance & MPH

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

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

is what I needed.

Nick

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1