MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting seconds to minutes:seconds format

Posted by Kit on August 13, 2001 11:05 AM


...anyone out there know how to convert the following:

390 seconds to 6:30 (where 6 is equal to minutes and 30 is equal to seconds).

I've been trying to figure it out but no luck. Simple but it evades me:(

Posted by Barrie Davidson on August 13, 2001 11:17 AM

Do you want your result to be a number or can the result be text?


Posted by Ian on August 13, 2001 12:13 PM

if you values in a1 put:


in B1


is 24*60*60

is day*hour*minute

if you wanted hour minute you would have put



you need to format the cell to time format (right mouse button Format_cells)

you can convert back to a whole number but multiplying by the same

Hope this helps