Split a date/time column into 2 columns

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
 

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
How to customize =Now() 11
Calculate the amount of time over a permitted amount (12 hours) 7
date 2
date format 1
Preserving date format 1
Time - Analysis based on time 3
Can't graph data with Date Format with hours 2

Top