Average minutes per mile

tateh973

unread,

Jan 1, 2007, 4:25:00 PM1/1/07

to

I'm a runner, and want to keep track of/work with my times. I want Excel to
tell me what my average time is per mile. So let's say cell b2 is the number
of miles (example, 4.0 miles) and cell c2 is my total time (37 minutes, 41
seconds). I want to know how many minutes per mile I've done. This is
probably really easy -- but Excel thinks I'm entering an actual clock time
(12:37:41 a.m.) vs. just a quantity of minutes/seconds. Can someone help me?
Thanks.

Niek Otten

unread,

Jan 1, 2007, 4:42:15 PM1/1/07

to

Enter 0:37:41
Time in Excel is stored as a fraction of a day.
So with your distance in B2 and your time in C2:

=B2/(C2*24*60)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"tateh973" <tate...@discussions.microsoft.com> wrote in message news:CC924896-26DF-4B93...@microsoft.com...

mcgrath383

unread,

Jan 1, 2007, 4:50:09 PM1/1/07

to

hi
a simple solution would be
b2 number of miles
c2 number of minutes
d2 number of seconds
in d3 convert the seconds to minutes e.g. =d2/60
To work out miles per minute suggest the formulas =b2/(c2+d3)
to work out minutes per mile will be the inverse e.g. =(c2+d3)/b2

this may seem long winded someone else might have a more straighforward
way

On Jan 1, 9:25 pm, tateh973 <tateh...@discussions.microsoft.com>
wrote:

David Biddulph

unread,

Jan 1, 2007, 4:49:36 PM1/1/07

to

Your formula for minutes/mile is =C2/B2.
You'll probably want to format the result (and C2) as something like m:ss.
When you enter the time in C2 you may need to do so as 0:37:41 or as 37:41.0
--
David Biddulph

"tateh973" <tate...@discussions.microsoft.com> wrote in message
news:CC924896-26DF-4B93...@microsoft.com...

T. Valko

unread,

Jan 1, 2007, 4:47:43 PM1/1/07

to

Format cell C2 as mm:ss

When you enter this time enter it as 0:37:41. It will show in the cell as
37:41 but in the formula bar it will show as 12:37:41 AM.

Then:

=C2/B2

Result is 09:25

You can format the formula cell as m:ss if you don't want the leading 0,
9:25

Biff

"tateh973" <tate...@discussions.microsoft.com> wrote in message
news:CC924896-26DF-4B93...@microsoft.com...

Niek Otten

unread,

Jan 1, 2007, 4:50:13 PM1/1/07

to

And format as General or Number, not Time (which is what Excel probably does automatically)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Keep discussions in the newsgroups- no private emails please
"Niek Otten" <nico...@xs4all.nl> wrote in message news:ecjcy2eL...@TK2MSFTNGP02.phx.gbl...

Niek Otten

unread,

Jan 1, 2007, 4:56:08 PM1/1/07

to

Right, Biff! I read miles per minute

--
Kind regards,

Niek Otten
Microsoft MVP - Excel
Keep discussions in the newsgroups- no private emails please

"T. Valko" <biffi...@comcast.net> wrote in message news:elgo55eL...@TK2MSFTNGP06.phx.gbl...

Gord Dibben

unread,

Jan 1, 2007, 5:02:12 PM1/1/07

to

Enter the time as 0:37:41 in C2 and format as mm:ss

Enter 4 in B2 and format as General

In A2 enter =C2/B2 and format as mm:ss

I get 9 minutes 25 seconds per mile.

Enter 1:12:00 in C2 and I get 18 minutes per mile......my top speed, I might
add.

Gord

On Mon, 1 Jan 2007 13:25:00 -0800, tateh973 <tate...@discussions.microsoft.com>
wrote: