View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michel Khennafi Michel Khennafi is offline
external usenet poster
 
Posts: 10
Default extracting time only

good morning

I have a seri of cells where the information inside is like

10/2/2007 4:38:00 PM

I would like to create 2 columns where in one of them I have the date only
and in the other I have the time only

Any idea as to what is the best thing to ddo?

Help is appreciated ... Thanks