convert seconds to minutes and seconds

**Richard Flame** · 02-20-2007, 02:43 PM

Hello,

If I have 155 seconds in a cell. How can I convert that to minutes and seconds (ex 155 will be 2:35). tks

**loumf** · 02-20-2007, 02:49 PM

I don't know if it can be done with a format. If you use this formula, it can format it as text (assumes the seconds are in A1)

=TEXT(A1/60, "00")&":"&TEXT(MOD(A1,60), "00")

**Richard Flame** · 02-20-2007, 02:52 PM

tks,

something is not quit correct..for 180 seconds it returns 3:00 which is correct. For 155 seconds it's returning 3:35 which is wrong.why is that??