+ Reply to Thread
Results 1 to 6 of 6

Text to Date/TIme conversion issue

  1. #1
    Registered User
    Join Date
    04-21-2015
    Location
    Serbia
    MS-Off Ver
    Office 365 64-bit
    Posts
    10

    Text to Date/TIme conversion issue

    Hello, I am struggling converting table with wrongly formatted date.
    I need to convert it to date European format dd.mm.yyyy hh:mm
    Time needs to be preserved as I am calculating DateDiff using another workbook with correct date format

    Any help appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Text to Date/TIme conversion issue

    Hi there,

    Try inserting the following formula in Cell B1 and copying it downwards:

    Please Login or Register  to view this content.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Text to Date/TIme conversion issue

    Better than my effort, which was longer. Don't forget that you may need ; instead of ,
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Registered User
    Join Date
    04-21-2015
    Location
    Serbia
    MS-Off Ver
    Office 365 64-bit
    Posts
    10

    Re: Text to Date/TIme conversion issue

    Perfect Greg, many thanks
    Had to replace , with ; and . with , but works like a charm

  5. #5
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Text to Date/TIme conversion issue

    Hi again,

    Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

    You're welcome - glad I was able to help.

    Best regards,

    Greg M

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Text to Date/TIme conversion issue

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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] Issue with Date conversion from Text to CDate with Format
    By rakotonirinas in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-20-2019, 12:23 PM
  2. Date conversion issue.
    By edleigh in forum Excel General
    Replies: 1
    Last Post: 03-12-2016, 05:37 PM
  3. Date conversion issue
    By dothanby in forum Excel General
    Replies: 1
    Last Post: 05-15-2015, 05:44 PM
  4. Time/Date Conversion based on a text input possible?
    By aleffingwell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2012, 11:27 AM
  5. conversion of text to time and date
    By afgi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2010, 12:08 PM
  6. Date conversion issue with year
    By maacmaac in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-12-2009, 05:38 PM
  7. Date conversion issue... again
    By Dimmer in forum Excel General
    Replies: 6
    Last Post: 07-11-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1