+ Reply to Thread
Results 1 to 3 of 3

Converting Unusable Time / Date Format To Usable Time / Date Format

  1. #1
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    332

    Converting Unusable Time / Date Format To Usable Time / Date Format

    I'm curious if someone can show me a formula that would convert a couple different variations of time & date formatted cells into correct or usable time and date formats.

    Currently, I have one column that has 20180109 05:06 in it and another column that has 20190102-01:13 in it... the only difference between the two is the hyphen. I need those separated into proper date and time columns.

    Here's an image of what I'm referring to. I have also attached an example worksheet
    Capture.PNG
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Converting Unusable Time / Date Format To Usable Time / Date Format

    Try this in D2:

    =--TEXT(LEFT(A2,8),"0000-00-00")

    in E2:

    =--RIGHT(A2,5)

  3. #3
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    332

    Re: Converting Unusable Time / Date Format To Usable Time / Date Format

    Quote Originally Posted by Phuocam View Post
    Try this in D2:

    =--TEXT(LEFT(A2,8),"0000-00-00")
    in E2:
    =--RIGHT(A2,5)
    Perfect! Thanks so much!

+ 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] Converting Date & Time (General format) to Date (Date format)
    By supremenuts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2017, 12:55 PM
  2. [SOLVED] converting binary date to date/time format
    By a2424 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-10-2014, 01:15 AM
  3. Replies: 4
    Last Post: 05-10-2014, 10:45 AM
  4. [SOLVED] Converting Text to Military Date Time Group Format
    By ET1CARNES in forum Excel General
    Replies: 9
    Last Post: 04-12-2014, 08:51 AM
  5. modify date time cell to an excel format date time
    By rileyp in forum Excel General
    Replies: 12
    Last Post: 03-24-2013, 08:39 PM
  6. Replies: 6
    Last Post: 03-19-2010, 12:26 PM
  7. [SOLVED] Date Format Question- convert into a usable date format.
    By Josh O. in forum Excel General
    Replies: 1
    Last Post: 02-10-2005, 06:06 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