software

I have numbers (time) imported as text so I cannot simply format the
cell to time.

does anybody know a formula that will convert this to the following

130702 - to - 01:07:02 PM
093506 - to - 09:03:06 AM
101607 - to - 10:16:07 AM
123958 - to - 12:39:58 AM
225409 - to - 10:54:09 PM--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: www.excelforum.com/member.php...oamp;userid=30167
View this thread: www.excelforum.com/showthread...hreadid=503133=TIME(LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))

and copy the formula down, then format all cells as hh:mm:ss AM/PM

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;jermsalermsquot; gt;
wrote in message
...
gt;
gt; I have numbers (time) imported as text so I cannot simply format the
gt; cell to time.
gt;
gt; does anybody know a formula that will convert this to the following
gt;
gt; 130702 - to - 01:07:02 PM
gt; 093506 - to - 09:03:06 AM
gt; 101607 - to - 10:16:07 AM
gt; 123958 - to - 12:39:58 AM
gt; 225409 - to - 10:54:09 PM
gt;
gt;
gt; --
gt; jermsalerms
gt; ------------------------------------------------------------------------
gt; jermsalerms's Profile:
www.excelforum.com/member.php...oamp;userid=30167
gt; View this thread: www.excelforum.com/showthread...hreadid=503133
gt;

Try this formula

=TEXT(A1,quot;00\:00\:00quot;) 0--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=503133
I tried Bob's 1st and it worked so Im sticking with it. I sure the other
one works well too--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: www.excelforum.com/member.php...oamp;userid=30167
View this thread: www.excelforum.com/showthread...hreadid=503133