Batch column converting (Date & Time)

laurennp

New member
Joined
Feb 12, 2013
Messages
1
Reaction score
0
Points
0
Hey guys,

I'm having trouble finding information on these two things:

__________________

First column says: "2013/2/5 12:56:23" which is date and time.

I need to delete the date, and convert the time to a 12-hour view, being "12:56 pm"

__________________

Then, I need all other rows underneath to revert to just showing the time as well. How can I batch format this?

(I have 20,000 rows which is why I cannot manually change each one)

__________________

Screenshot of original:
timestamp_sceenshot.jpg
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Why not just format them all in that manner?
 
Top