+ Reply to Thread
Results 1 to 3 of 3

How to make a text formated date be detected as a date so I can calculate the time between

  1. #1
    Registered User
    Join Date
    11-21-2018
    Location
    Barcelona
    MS-Off Ver
    365 2018
    Posts
    2

    Lightbulb How to make a text formated date be detected as a date so I can calculate the time between

    Hi team,

    I have a file coming from a personally created database, and one of the most important files comes like this.


    2017-12-11 19:46:39.000
    2017-12-11 21:09:45.000

    I can't find any way for excel to detect that as a date so I can operate with it. If you have any ideas I would be really thankful.

    Thanks a lot in advance,

    It must be kinda simple but I cannot find the way

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: How to make a text formated date be detected as a date so I can calculate the time bet

    Try this one

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-21-2018
    Location
    Barcelona
    MS-Off Ver
    365 2018
    Posts
    2

    Re: How to make a text formated date be detected as a date so I can calculate the time bet

    Oh that worked perfectly! Thanks a lot!

    I didn't know abou that -- use.

    Regards!

+ 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] extracting the number on the right of decimal of a date & time formated cell
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2015, 03:17 AM
  2. [SOLVED] Calculate time remaining based on end date & time and current date
    By Kaz09 in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 08-19-2014, 07:11 AM
  3. Copy Formated Date to Text for Mailmerge
    By at60 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2014, 11:31 AM
  4. Replies: 3
    Last Post: 12-19-2013, 06:49 AM
  5. [SOLVED] Calculate number of hours from Start date and time and End date and time
    By sathyasun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2013, 01:04 AM
  6. Combining Custom Formated Date with Text in new cell
    By sighlent1 in forum Excel General
    Replies: 2
    Last Post: 07-22-2009, 02:22 PM
  7. [SOLVED] How do I convert a number formated as a date to text in Excel?
    By BrotherNov in forum Excel General
    Replies: 6
    Last Post: 03-02-2005, 12: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1