Hi,

Am Wed, 25 Sep 2013 14:26:57 -0400 schrieb wabbleknee:

I have not had much problem with this type in the past, but this one seems
to want to be difficult. 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"
What I want to extract is only time to be shown as 16:10. What seemed to
work in the past is to do a "text to columns" and then to make one column =
4:10:00 PM. Then format as 13:30, but getting the 4:10:00 PM in that
format requires a lot of extra steps beforehand.
Would appreciate a more simple conversion if possible. (A text to columns
attempt makes 4:10:00 PM show up as 4:10:00 AM in first cell, PM shows up in
the next cell)??

your values in column A
Then in B1:
=MOD(A1,1)
and format h:mm


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