XL stores times as fractional days, so to convert integer seconds to an
XL time (minutes and seconds), divide by 24*60*60:

A1: 123
A2: =A1/86400

which will display 2:03 when formatted as [m]:ss


In article ,
anonymous wrote:

I need a formula which converts seconds to minutes and seconds.