Thanks for both of your suggestions David - I'll give it a shot!

"David Biddulph" wrote:

If your "times" in mm.ss format (with a decimal point instead of a colon)
are in column A, then put =TIME(0,INT(A1),100*MOD(A1,1)) in B1, then copy
that cell as far as you need down column B (& format B as [m]:ss).
--
David Biddulph

"Janis" wrote in message
...
Thank you for your reply David.
Could you please tell me where I enter the formula the 'helper column'? In
the formula bar or in the custom cell options?