try this. set the cell format to custom - "mm:ss". and type in this formula
where B6 represents a cell holding the number 212

=TIME(,,B6)

"mike" wrote:

I want to convert 212 seconds to mn:sec format in Excell