View Single Post
  #1   Report Post  
marc grody marc grody is offline
Junior Member
 
Posts: 1
Default Seperating Date and Time

Hi

I am looking for some help in reformatting the Date and Time. I have imported a large amount of data into EXCEL. The Date and Time are currently shown in one field in the format dd/mm/yyyy hh::mm. I need to seperate them into two fields - date and time. Any assistance would be greatly appreciated. Thank you