+ 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
    7

    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 2013
    Posts
    2,968

    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
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    23,370

    Re: Text to Date/TIme conversion issue

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



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

    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 2013
    Posts
    2,968

    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
    MS-Off Ver
    MS Office 2019
    Posts
    16,260

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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