That seems to work....Tx

"shanermuls" wrote in message ...


Claus Busch;1614046 Wrote:
Hi again,

Am Wed, 25 Sep 2013 20:37:40 +0200 schrieb Claus Busch:
-
I get an excel sheet mailed to me that shows an
event time. i.e. "9/24/2013 4:10:00 PM". As received, the custom
format -
now is "mm/dd/yyyy hh:mm:ss AM/PM"--

or first format your column custom as mm/dd/yyyy h:mm:ss and then run
TextToColumns


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

"=text(a1, "hh:mm")" may work also




--
shanermuls