I imported a table with several columns. One was START TIME 06/01/2013 12:30 PM where the /0l/ is the month. I managed to separate into two columns = START DATE | START TIME. I then managed to format the Start Date. I cannot format the START TIME.
CURRENT FORMAT = ' 06:27 PM instead of 06:27 PM.
How do I strip the apostrophe that is making it a label instead of time? Search & Replace failed. Formatting the cell failed. I have another column that is the end time so there's 143 entries x 2.
A B C D
START DATE START TIME END TIME HOURS
01 JAN 2013 12:00 PM 1:00 AM 13:00 <<<==(C2<B2)+C2-B2 this is in HELP(Calculating Time Differences ) but untested formula