+ Reply to Thread
Results 1 to 9 of 9

Need to convert the below format date and time in DD-MM-YYYY HH:MM in excel

  1. 12-22-2023, 01:49 PM #1
    zeeshansyed
    zeeshansyed is offline
    Registered User
    Join Date
    12-22-2023
    Location
    bangalore
    MS-Off Ver
    16
    Posts
    1

    Need to convert the below format date and time in DD-MM-YYYY HH:MM in excel

    Screenshot 2023-12-22 231701.png

    Need to convert the below format date and time in DD-MM-YYYY HH:MM in excel
    Reply With QuoteRegister To Reply
  2. 12-22-2023, 02:59 PM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Need to convert the below format date and time in DD-MM-YYYY HH:MM in excel

    With a date in A1

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JohnTopley; 12-22-2023 at 03:09 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 12-22-2023, 03:27 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Need to convert the below format date and time in DD-MM-YYYY HH:MM in excel

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 12-22-2023, 10:38 PM #4
    Gregb11
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,831

    Re: Need to convert the below format date and time in DD-MM-YYYY HH:MM in excel

    Just another option:
    =DATEVALUE(A1)+TIMEVALUE(A1)
    Reply With QuoteRegister To Reply
  5. 12-22-2023, 11:39 PM #5
    josephteh
    josephteh is offline
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,059

    Re: Need to convert the below format date and time in DD-MM-YYYY HH:MM in excel

    The date format "Oct 19, 2023" may not be recognisable in India. Both TMS and Gregb11 formulas returned "#VALUE!" on my computer. Another way is to use Power Query.
    Reply With QuoteRegister To Reply
  6. 12-23-2023, 04:29 AM #6
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Need to convert the below format date and time in DD-MM-YYYY HH:MM in excel

    Returned #VALUE on mine too which may reflect that I have Excel 2010 Hence my convoluted reply!

    As far as I can discover, DATEVALUE does not recognise formats such as the "OCT 19, 2023" or "OCT 19 2023".
    Last edited by JohnTopley; 12-23-2023 at 04:52 AM.
    Reply With QuoteRegister To Reply
  7. 12-23-2023, 05:08 AM #7
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Need to convert the below format date and time in DD-MM-YYYY HH:MM in excel

    Oddly, it worked on my iPad but not on my Windows laptop. On my laptop, if I changed the text string to "19 Oct, 2023" then Excel recognised it and converted it in situ. I had to put a single quote in front of the string to retain the text format to test the formulae.
    Reply With QuoteRegister To Reply
  8. 12-23-2023, 05:11 AM #8
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Need to convert the below format date and time in DD-MM-YYYY HH:MM in excel

    DATEVALUE does recognise the "DD MM YYYY" (and variants) format but not "MM DD YYYY".
    Reply With QuoteRegister To Reply
  9. 12-23-2023, 05:23 AM #9
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,428

    Re: Need to convert the below format date and time in DD-MM-YYYY HH:MM in excel

    What DATAVALUE does and does not recognize depends on local settings (language settings).
    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. Convert Date in mmm yyyy format
    By bhenlee in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-14-2023, 07:18 AM
  2. Excel 2021 - how to set format for date&time as 'dd.MM.yyyy HH:mm'?
    By senglory in forum Excel General
    Replies: 2
    Last Post: 05-01-2023, 08:39 AM
  3. Convert Date in DD.MM.YYYY to DD/MM/YYYY format
    By abhinavbinkar in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-21-2019, 07:18 AM
  4. Convert Date format from Text format reading m/d/yyyy to dd/mm/yyyy
    By bridge4444 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-23-2017, 11:22 PM
  5. [SOLVED] How to Convert date format ( DD/MM/YYYY) into MM/YYYY
    By PRADEEPB270 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2014, 07:25 AM
  6. [SOLVED] Convert Date Format from yyyy-mm-dd to dd mmm yy using VBA
    By longbow007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2012, 07:36 AM
  7. [SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB
    By Boormo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-05-2012, 05:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1