In an unused cell enter 1440 then copy it and Paste Special into A1 using
the Divide option of Paste Special then format A1 as "m:ss" (without the
quotes)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"HumingBean" wrote in message
oups.com...
Hello, all,

The Time functions in my Excel 2000 no doubt can do what I want, but I
can't fugure out a solution.

Assume that in Cell A1 I have the number 12.25, which represents 12
minutes and 15 seconds, i.e., it is a decimal representation of 12
minutes and another .25 of a minute.

Is there a way to get Cell A2 to show the following (without the
quotes)?

"12:15"

That's "12 colon 15"

Thanks.