If A2 is your number of minutes as a decimal number, then use =A2/(24*60)
and format as time (such as [m]:ss). [This works because Excel dates and
times are in days, so convert from minutes to days.]

You didn't need to do the conversion the long way round converting to
decimals and back again. You could put in the 31:12 as either 0:31:12 or as
31:12.0 (but not as 31:12 because that would be treated as hh:mm, not as
mm:ss), and then just divide by 4.
--
David Biddulph

"RuSLMaN" wrote in message
...
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