software

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.

quot;Elvinquot; gt; wrote in message
...
gt; how can i convert in excel whole numbers (ex 234) representing seconds to
gt; mm:ss

hi!

try this!!

=TEXT(A1/86400,quot;mm:ssquot;)

assuming your number is in A1

-via135

gt; Hi
gt;
gt; Divide it by 1440 and format as time.
gt;
gt; Andy.
gt;
gt; quot;Elvinquot; gt; wrote in message
gt; ...
gt; gt; how can i convert in excel whole numbers (ex 234) representing
gt; seconds to
gt; gt; mm:ss--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=519162