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:	14 
Size:	80.8 KB 
ID:	1134

  2. #2
    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
  •