View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wabbleknee wabbleknee is offline
external usenet poster
 
Posts: 31
Default separating date and time

Greetings

I have some formatted data that looks like this:
A
1 04/01/2013 12:00:00 PM
2 04/03/2013 09:00:00 AM
3 04/03/2013 01:45:00 PM

I would like to have the resulting data to look like this

A B
1 04/01/2013 12:00
2 04/03/2013 09:00
3 04/03/2013 13:45

Date in separate column with no time stamp remaining
Time in a separate column with no date stamp remaining
Time is 24 hr format.

I can format A1 04/01/2013 12:00:00 PM with mm/dd/yyyy
the cell will show 04/01/2013 but 12:00:00 still remains in the cell.
I want all time references removed. B1 only time.

Any help appreciated. Tx