Thanks to both of you (Bill and Dave). Both ways seem to work. I had one
more question for you, if you are inputing your time, would you recommend
splitting it into 2 columns (one for minutes and one for seconds) or is there
a way to put the time in one column and include both minutes and seconds and
then use that for the pace calculation?

For example:
One column Vs Two Columns

|Time (mm:ss)| |Minutes|Seconds|
| 31:12 | | 31 | 12 |

Thanks again for any help!

Russ

"RuSLMaN" wrote:

Whenever I try to calculate a running pace (minutes/per mile) it returns a
number in decimal form. But the decimal then has to be converted to seconds.


For example, I want to calculate my pace (minutes/mile) if I ran 4 miles in
31 minutes and 12 seconds. To get an accurate pace, I have to convert 31
minutes and 12 seconds to a decimal format which would be equal to 31.2
minutes. (12 seconds divided by 60 seconds = .2)


Then when I divide 31.2 minutes by 4.0 miles the answer I get in Excel is
7.80.

Since there are only 60 seconds in a minute, 7.80 is actually 7 minutes and
48 seconds per mile. (0.8 x 60 seconds) Is there a function in Excel that
can convert decimals to minutes and seconds without having to do some
advanced programming?

Any ideas?

Thanks,
RuSL