Hi,
Would like to seek your advise on how to convert the following example to date and time format using formula :
Mon Jul 11 10:19:28 WST 2016
Wed Aug 02 09:09:49 MYT 2017
Thank you
Chitra
Hi,
Would like to seek your advise on how to convert the following example to date and time format using formula :
Mon Jul 11 10:19:28 WST 2016
Wed Aug 02 09:09:49 MYT 2017
Thank you
Chitra
hi Chitra. try:
=--(MID(A1,9,2)&MID(A1,5,3)&RIGHT(A1,4)&" "&MID(A1,12,8))
format to a date and time format desired. for eg.
ddd-mmm-yy hh:mm:ss
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you so much. It worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks