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)?? Tx