Results 1 to 2 of 2

Thread: Batch column converting (Date & Time)

  1. #1

    Batch column converting (Date & Time)

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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:
    Click image for larger version. 

Name:	timestamp_sceenshot.jpg 
Views:	15 
Size:	80.8 KB 
ID:	1134

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Why not just format them all in that manner?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts