excel training log question

determined said:

I've been tracking my distance and time, but would like to see it converted
to pace. What is the formula I'd use for that? Say I did 2 miles in 18
minutes. So I have 2 in the first column, and 18 in the second column...
When I try to get something that looks like mm:ss in the 3rd column, it just
returns zeros.

I guess I know just enough to be dangerous...

Personally I find it easy to just put my time into excel in decimal
form. Eliminates the need for using macros and complex functions. So
for instance lets say I ran 5 miles in 37:30 (easy numbers being used
here). In column b (I put the date in A) I would put a 5 for the
miles. In column c I put the time in, in this formate =37+30/60. That
would give me the number 37.5 for time. To get pace divide time and
distance =c/b. I do get a decimal number but since I am not overly
concerned about 2-3 seconds I just know that every .25 minutes = 15
seconds. Its real easy.

I am sure that excel can do the minutes:seconds thing but since I
don't want to spend a lot of time doing excel functions (its what I do
all day for work), I just do it the simple way.

John

determined said:

I've been tracking my distance and time, but would like to see it converted
to pace. What is the formula I'd use for that? Say I did 2 miles in 18
minutes. So I have 2 in the first column, and 18 in the second column...
When I try to get something that looks like mm:ss in the 3rd column, it just
returns zeros.

I guess I know just enough to be dangerous...

You might check the format on your "results" cell and be sure it's a
time format like "37:30:55" (at least that's what shows in my "format
cells" / number options).

I just entered 2, 0:18:00, +b2/a2 in cols a, b, c and got 0:09:00 in c.

(Access isn't as nice, or I don't have something set up right in it to
do the calcs this way. I need the fcns there.)

Dot

--
"The goal is training and adaptation, not destruction and injury."
- John Hardy
http://www.mountainrunning.coolrunning.com.au/misc/training.shtml

Dot dot.h@#duh?att.net said:

determined said:

I've been tracking my distance and time, but would like to see it converted
to pace. What is the formula I'd use for that? Say I did 2 miles in 18
minutes. So I have 2 in the first column, and 18 in the second column...
When I try to get something that looks like mm:ss in the 3rd column, it just
returns zeros.

Quoted message said:

I guess I know just enough to be dangerous...

You might check the format on your "results" cell and be sure it's a
time format like "37:30:55" (at least that's what shows in my "format
cells" / number options).

I just entered 2, 0:18:00, +b2/a2 in cols a, b, c and got 0:09:00 in c.

(Access isn't as nice, or I don't have something set up right in it to
do the calcs this way. I need the fcns there.)

Dot

--
"The goal is training and adaptation, not destruction and injury."
- John Hardyhttp://www.mountainrunning.coolrunning.com.au/misc/training.shtml

Hi I just found a website that does the calculation for you have a
look at http://www.runcalc.com/convert.htm

determined said:

I've been tracking my distance and time, but would like to see it converted
to pace. What is the formula I'd use for that? Say I did 2 miles in 18
minutes. So I have 2 in the first column, and 18 in the second column...
When I try to get something that looks like mm:ss in the 3rd column, it just
returns zeros.

I guess I know just enough to be dangerous...

Hello,

So from what I've read it seems that you have two or three columns,
one for each "portion" of a time, i.e. one for hours, one for minutes,
one for seconds.

Start by concatenating these into one column. I made a spreadsheet
where I have hours in A, minutes in B, and seconds in C. To
concatenate these, I went into the D column (cell D2, specifically)
and entered the following formula:

=A2&":"&B2&":"&C2

The & concatenates data, so this says "Take A2, follow it with a
colon, then b2, then another colon, and end with c2"

Now D2 contains 0:22:18. Next format column D. Select it, right-click,
and pick 'Format Cells' Go to custom, and choose h:mm:ss. It's about
2/3rds of the way down the list.

Next I entered my distance in E2. I chose 3.3 miles in this case.
Column E does not need any special formatting.

I then did pace in Column F. I just entered the formula:

=D2/E2

and got the result 0.004692761.

I then formatted Column F with the same Custom->h:mm:ss format that
was used in Column D, and the pace was displayed as 0:06:45. Use the
mm:ss format and you can get rid of the leading 0 that represents the
'hours' portion of the time, i.e. it will look like 06:45.

Hopefully that will be easily adaptable to your spreadsheet.

There's a set of Newsgroups, microsoft.public.excel.*, that have been
a great resource for Excel stuff for me in the past. Whenever I have
an Excel problem, I often find that somebody else has already had the
same problem and recieved a solution there.

- Sean C.

how cool. Thanks.

"SMC" <[email hidden]> wrote in message
news:[email hidden]...

Quoted message said:

determined said:

I've been tracking my distance and time, but would like to see it
converted
to pace. What is the formula I'd use for that? Say I did 2 miles in 18
minutes. So I have 2 in the first column, and 18 in the second column...
When I try to get something that looks like mm:ss in the 3rd column, it
just
returns zeros.

I guess I know just enough to be dangerous...

Hello,

So from what I've read it seems that you have two or three columns,
one for each "portion" of a time, i.e. one for hours, one for minutes,
one for seconds.

Start by concatenating these into one column. I made a spreadsheet
where I have hours in A, minutes in B, and seconds in C. To
concatenate these, I went into the D column (cell D2, specifically)
and entered the following formula:

=A2&":"&B2&":"&C2

The & concatenates data, so this says "Take A2, follow it with a
colon, then b2, then another colon, and end with c2"

Now D2 contains 0:22:18. Next format column D. Select it, right-click,
and pick 'Format Cells' Go to custom, and choose h:mm:ss. It's about
2/3rds of the way down the list.

Next I entered my distance in E2. I chose 3.3 miles in this case.
Column E does not need any special formatting.

I then did pace in Column F. I just entered the formula:

=D2/E2

and got the result 0.004692761.

I then formatted Column F with the same Custom->h:mm:ss format that
was used in Column D, and the pace was displayed as 0:06:45. Use the
mm:ss format and you can get rid of the leading 0 that represents the
'hours' portion of the time, i.e. it will look like 06:45.

Hopefully that will be easily adaptable to your spreadsheet.

There's a set of Newsgroups, microsoft.public.excel.*, that have been
a great resource for Excel stuff for me in the past. Whenever I have
an Excel problem, I often find that somebody else has already had the
same problem and recieved a solution there.

- Sean C.