Time to Text w Custom Format

[bruegel]

I have the cell formatted to [mmm]:ss (which shows hh:mm:ss in the formula bar) I want to convert the [mmm}:ss to text for use in a database. e.g. 071:12 custom display format (seventy one minutes twelve seconds) to text format 071:12

Tried numerous TEXT worksheet functions but can't find one that works

Thanks

Pieter

[xlnitwit]

Hi,

What is the result if you use
=TEXT(A1,"[mmm]:ss")

[Neil_]

=TEXT(A1,"[m]:ss")

[TMS]

Please Login or Register  to view this content.

[bruegel]

=TEXT(A1,"[mmm]:ss")

seemed to work. Weird as it's one of the first things I tried.

=TEXT(A1,"[m]:ss") lost any leading zeros. Only picked up digits >1

Thanks for help

Peter

[TMS]

=TEXT(A1,"[mmm]:ss")

seemed to work. Weird as it's one of the first things I tried.

The square brackets are, I think, the important thing here, together with the three "m"s for minutes.