View Single Post
  #5  
Old 06-03-2012, 03:52 PM
mar2a mar2a is offline
Junior Member
 
Join Date: Jun 2012
Posts: 14
Default

I think I just found an easy way to do it!

With Google, I found this page:
http://en.allexperts.com/q/Excel-105...-time-cell.htm

  1. Create two new columns.
  2. Copy the combined date/time column into each one.
  3. Highlight the first copied column. Change the format to Short Date. (Use Format Cells > Date).
  4. Highlight the second copy. Change the format to Time (Use Format Cells > Date).

I'm using the American time and date formats, but you can choose whatever format you want.
Reply With Quote