To expand - I would like to do this when the number is the result of a MAX
formula. I have tried using the custom mm:ss format but this just gives me
the result 00:00 for some reason.

"JaB" wrote:

Hi there

Does anyone know how to convert a number into minutes and seconds in the
following format - mm:ss

Many thanks