add format to =MIN formula to display as mm:ss

[redspanna]

Hi all

I have a formula which I wish to include TEXT and a formula.

Text will be : and your lowest time will be


then add to that a formula to find lowest score on the 'Pivots data' page through column I

formula like : MIN('Pivots data'!I:I)

then add more TEXT like well done


final complete formula I have looks like


=" and your lowest time will be"&MIN('Pivots data'!I:I)&" well done"


however the results look like


and your lowest time will be 0.14354548375743 well done


how can I add a TEXT format to the formula to show the result as mm:ss ?

thanks in advance

 

[mikerickson]

Perhaps
=" and your lowest time will be" & TEXT(MIN('Pivots data'!I:I), "mm:ss") & " well done"

 

[redspanna]

Thank you, couldn't quite figure where/how to place the "mm:ss" part

Cheers