+ Reply to Thread
Results 1 to 8 of 8

Different Date / Time formats

  1. 06-27-2018, 05:16 AM #1
    TomasP
    TomasP is offline
    Registered User
    Join Date
    06-27-2018
    Location
    bratislava
    MS-Off Ver
    2016
    Posts
    3

    Different Date / Time formats

    Hello

    Could you please advise what code I should use to unify below 2 date/time formats

    4/16/2018 3:07 PM
    17.4.2018 9:26


    I would like to have dd/mm/yyyy hh:mm

    Thank you
    Reply With QuoteRegister To Reply
  2. 06-27-2018, 05:26 AM #2
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    O365 V2408
    Posts
    15,157

    Re: Different Date / Time formats

    like this...
    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 06-27-2018, 05:33 AM #3
    TomasP
    TomasP is offline
    Registered User
    Join Date
    06-27-2018
    Location
    bratislava
    MS-Off Ver
    2016
    Posts
    3

    Re: Different Date / Time formats

    Thanks

    This is giving me Run-Time error 13

    I guess challenge here will be that its not being recognized as a date even when trying to change this via Text to Columns
    Reply With QuoteRegister To Reply
  4. 06-27-2018, 05:39 AM #4
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    O365 V2408
    Posts
    15,157

    Re: Different Date / Time formats

    what is format of cells...
    Edit...
    Perhaps this...
    Please Login or Register  to view this content.
    Last edited by Sintek; 06-27-2018 at 05:44 AM.
    Reply With QuoteRegister To Reply
  5. 06-27-2018, 05:45 AM #5
    TomasP
    TomasP is offline
    Registered User
    Join Date
    06-27-2018
    Location
    bratislava
    MS-Off Ver
    2016
    Posts
    3

    Re: Different Date / Time formats

    Its export where both are formatted as text.
    Reply With QuoteRegister To Reply
  6. 06-27-2018, 06:05 AM #6
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    O365 V2408
    Posts
    15,157

    Re: Different Date / Time formats

    Can you upload a sample file...
    Reply With QuoteRegister To Reply
  7. 06-27-2018, 06:06 AM #7
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,835

    Re: Different Date / Time formats

    4/16/2018 3:07 PM
    17.4.2018 9:26
    5.6.2018 10:30

    How do you know d.m.yyyy or m.d.yyyy?
    Reply With QuoteRegister To Reply
  8. 06-27-2018, 06:34 AM #8
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    O365 V2408
    Posts
    15,157

    Re: Different Date / Time formats 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : Converting to date and time formats
    By ronbailey in forum Excel General
    Replies: 3
    Last Post: 06-28-2011, 12:13 PM
  2. Excel 2007 : How to convert various date formats with time to dd-mmm-yy format?
    By novodisc in forum Excel General
    Replies: 5
    Last Post: 10-18-2010, 05:54 AM
  3. Date & time formats issue
    By Redder Lurtz in forum Excel General
    Replies: 2
    Last Post: 12-02-2009, 04:14 AM
  4. Changing date time formats in EXCEL
    By gordo29 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-30-2008, 03:21 PM
  5. [SOLVED] What exactly does the asterisk mean in the Date/Time formats?
    By jb in forum Excel General
    Replies: 1
    Last Post: 07-25-2006, 09:45 PM
  6. [SOLVED] Date and Time Formats in UserForms
    By Zani in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2006, 12:25 AM
  7. [SOLVED] Multiple Date/Time Formats
    By colin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2005, 07:05 AM
  8. [SOLVED] US vs UK date and time formats
    By Stephen Glynn in forum Excel General
    Replies: 2
    Last Post: 02-24-2005, 04:06 PM

Tags for this Thread

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1