But why would he want to display as 7.48 (which it isn't) in place of 7:48
(which it is)?
--
David Biddulph

"Bill Sharpe" wrote in message
...

Not quite programming, but a bit of function/formula work.

If 7.8 is in A1 then place this formula in another cell:
=INT(A1)+(A1-INT(A1))*60/100.
First part gives you 7; second part gives you 0.8, and the
multiplication/division gives you .48. You could shorten 60/100 to 0.6.
You may also want to format the cell to display only two decimal places.

Bill

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