Split a date/time column into 2 columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to split a date/time column ie. mm/dd/yy hh:mm:ss AM/PM. Into 2
columns
1. mm/dd/yy and 2. hh:mm

I'm using excel 2003
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I delete merged cells in Excel without deleting the final d 5
Calculate the amount of time over a permitted amount (12 hours) 7
How to customize =Now() 11
date 2
date 1
date format 1
Preserving date format 1
Time - Analysis based on time 3

Back
Top