You could use a helper cell with a formula:

=A1/24/60/60

And format it as mm:ss (or your favorite format)



DaveWHAC wrote:

I'm trying to set up a spreadsheet so that I can enter seconds into a variety
of cells e.g. 85 but I want it to be displayed as 1:25 when looking at the
spreadsheet.

Can anyone help ?

--

Dave Peterson