Katie,

Try this

=A1/(24*60*60)

Format as hh:mm:ss

Mike

"Katie" wrote:

I want to change data that is just a normal number into mins and seconds.
e.g. 80 --- 1:20 or 1.20 or something, so it is recognisable as 1 minute 20
seconds

Katie.