+ Reply to Thread
Results 1 to 3 of 3

Convert date and time format using formula

  1. #1
    Forum Contributor
    Join Date
    05-22-2015
    Location
    Malaysia
    MS-Off Ver
    MS365
    Posts
    197

    Convert date and time format using formula

    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

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Convert date and time format using formula

    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

  3. #3
    Forum Contributor
    Join Date
    05-22-2015
    Location
    Malaysia
    MS-Off Ver
    MS365
    Posts
    197

    Re: Convert date and time format using formula

    Thank you so much. It worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] convert date and time to different format
    By freddie1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2017, 06:17 AM
  2. Convert Date and Time to Date - Format problems
    By eugbed in forum Excel General
    Replies: 5
    Last Post: 05-03-2015, 05:31 PM
  3. Formula > Convert date to time format
    By Ransom12 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-26-2014, 04:18 PM
  4. Convert date and time in serial number format to text format
    By nda13112 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-11-2013, 02:45 PM
  5. [SOLVED] How do I convert imported date/time data to date/time format?
    By andykent99 in forum Excel General
    Replies: 4
    Last Post: 01-03-2013, 07:47 AM
  6. Need Formula/VBA Code to convert date in String Format to Normal Date format
    By Karthik Sen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2012, 04:54 AM
  7. convert Date Time format
    By yourskarthik in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-30-2009, 01:29 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1