software

I'm importing data (ASCII format) into Excel. There is a col for time
with values like 1411 for 2:11 and so on. When I try to format this col
for quot;Timequot; it changes all the values to quot;0:00quot;. Any Ideas how I can
correct this so that it will format correctly (i.e 1411 to 14:11 or
2:11) Thanks.--
jimbob
------------------------------------------------------------------------
jimbob's Profile: www.excelforum.com/member.php...oamp;userid=29107
View this thread: www.excelforum.com/showthread...hreadid=523723This =TIME(A1/100,MOD(A1,100),0)
gives 2:11 PM
when A1 has value 1411

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;jimbobquot; gt; wrote in
message ...
gt;
gt; I'm importing data (ASCII format) into Excel. There is a col for time
gt; with values like 1411 for 2:11 and so on. When I try to format this col
gt; for quot;Timequot; it changes all the values to quot;0:00quot;. Any Ideas how I can
gt; correct this so that it will format correctly (i.e 1411 to 14:11 or
gt; 2:11) Thanks.
gt;
gt;
gt; --
gt; jimbob
gt; ------------------------------------------------------------------------
gt; jimbob's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29107
gt; View this thread: www.excelforum.com/showthread...hreadid=523723
gt;
One more...

Add a helper column of formulas like:
=--(TEXT(A1,quot;00\:00quot;))

And format it as time.

jimbob wrote:
gt;
gt; I'm importing data (ASCII format) into Excel. There is a col for time
gt; with values like 1411 for 2:11 and so on. When I try to format this col
gt; for quot;Timequot; it changes all the values to quot;0:00quot;. Any Ideas how I can
gt; correct this so that it will format correctly (i.e 1411 to 14:11 or
gt; 2:11) Thanks.
gt;
gt; --
gt; jimbob
gt; ------------------------------------------------------------------------
gt; jimbob's Profile: www.excelforum.com/member.php...oamp;userid=29107
gt; View this thread: www.excelforum.com/showthread...hreadid=523723

--

Dave Peterson