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" wrote in message
...
how can i convert in excel whole numbers (ex 234) representing
seconds to
mm:ss


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=519162