how to convert whole numbers representing seconds to mm:ss

how can i convert in excel whole numbers (ex 234) representing seconds to mm:ss

Hi

Divide it by 1440 and format as time.

Andy.

"Elvin" <[email protected]> wrote in message
news:[email protected]...
> how can i convert in excel whole numbers (ex 234) representing seconds to
> mm:ss

hi!

try this!!

=TEXT(A1/86400,"mm:ss")

assuming your number is in A1

-via135

Hi

Divide it by 1440 and format as time.

Andy.

"Elvin" <[email protected]> wrote in message
news:[email protected]...
> how can i convert in excel whole numbers (ex 234) representing seconds to
> mm:ss