On Sat, 24 Feb 2007 12:32:08 -0800, Teethless mama
wrote:

Preformat cells as Text in Column A
Create a helper Column B

In B1: =IF(A1="","",TIME(0,LEFT(A1,FIND(":",A1)-1),RIGHT(A1,FIND(":",A1)-1)))

Format cell as [m]:ss

Why does that custom formatting work? I thought the brackets were for
conditional formatting? Where is this documented?

It turns out that "[s]" will show total seconds, too.

So many hidden goodies in Excel. It's like a scavenger hunt.

--
Running Excel 2000 SP-3 on Windows 2000