On Oct 22, 4:45 pm, "Sandy Mann" wrote:
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)

Sandy Mann, thanks for responding, but I'm not sure I understand. If I
Paste Special into cell A1, won't that change it? I don't want to
alter A1, I want to have a different representation of its contents in
a DIFFERENT cell, say, A2.

Also, what is 1440? Why not 1480? Needless to say, I want this to
work for any decimal number in A1 such as 4.1 (four minutes and six
seconds) or 78.5 (seventy-eight minutes and 30 seconds).

Thanks.