Results 1 to 10 of 20

Thread: Extract Date and time from the Text Column

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 08-18-2016, 07:52 PM #1
    zorro
    zorro is offline
    Junior Member
    Join Date
    Aug 2016
    Posts
    12
    Rep Power
    0
    It works, just that it is picking the time only in AM, even if it is PM
    Reply With Quote Reply With Quote
  2. 08-18-2016, 08:09 PM #2
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Quote Originally Posted by zorro View Post
    It works, just that it is picking the time only in AM, even if it is PM
    Sorry, I forgot to add 2 in order to retain the AM/PM designation. Here is the revised formula....
    Code:
    =IFERROR(0+SUBSTITUTE(TRIM(LEFT(RIGHT(SUBSTITUTE(LEFT(A1,IFERROR(FIND(" PM",A1)+2,FIND(" AM",A1)+2))," ",REPT(" ",300)),1500),1500)),",","",2),"")
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Extract Time from a Date&time cell
    By Feebles in forum Excel Help
    Replies: 4
    Last Post: 11-09-2015, 06:24 AM
  2. Extract Only Numbers & TEXT From Text String
    By mahmoud-lee in forum Excel Help
    Replies: 9
    Last Post: 11-02-2013, 02:49 PM
  3. How To Change Date Based On Time Using Formula
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 08-03-2013, 11:03 PM
  4. Date & Time Formats in Different Languages
    By Haseeb A in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 06-10-2012, 02:57 PM
  5. Displayin Date/Time in "original" time zone
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-21-2012, 02:02 AM

Bookmarks

Posting Permissions

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

Forum Rules