Hi All,

I have a column of cells that I am getting from an external datasource
that comes to me in long value, eg: 24.589265... This value is a
representation of the average seconds to complete a task. I would like to
format the cell in 'MM:ss' but the conversion process looks at the number as
days in a year and not as seconds.
I know I could use a formula to derive the minutes and seconds but I was
hoping there is a cell formatting I could use.

TIA,
Aaron