+ Reply to Thread
Results 1 to 2 of 2

Extracting Data from DateTime Stamp from Database

  1. 08-10-2015, 08:01 AM #1
    ashu611
    ashu611 is offline
    Registered User
    Join Date
    06-23-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    4

    Extracting Data from DateTime Stamp from Database

    Hi Gurus !

    I am stuck need help. I have excel file from Database which has date time column like this "07/29/15 8:50am EDT". Excel reads it as text and not date time. Help me to format it correctly.

    thanks
    Reply With QuoteRegister To Reply
  2. 08-10-2015, 08:25 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Extracting Data from DateTime Stamp from Database

    If your value is in A1, Put this in B1

    Please Login or Register  to view this content.
    Cheers!
    Deep Dave
    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. [SOLVED] Extracting data from database
    By pnnaik in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-27-2015, 01:51 AM
  2. [SOLVED] Removing Seconds from Datetime stamp
    By mangesh in forum Excel General
    Replies: 2
    Last Post: 07-04-2014, 03:19 AM
  3. Count Occurrences of time stamp bewteen two times from DateTime Column
    By headric in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2014, 09:08 AM
  4. [SOLVED] a problem extracting data from a database
    By boaz133 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-01-2013, 02:12 AM
  5. Extracting data from a database
    By MitchS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2011, 09:15 AM
  6. Based on a Column datetime value auto calculate and populate a datetime range
    By rajashanmuga in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2010, 04:10 PM
  7. Extracting data from database
    By rbalaji_it in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2007, 09:31 AM

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