+ Reply to Thread
Results 1 to 4 of 4

Split datetime to date and time

Hybrid View

mdek Split datetime to date and... 02-05-2016, 05:36 PM
JieJenn Re: Split datetime to date... 02-05-2016, 05:42 PM
mdek Re: Split datetime to date... 02-05-2016, 05:50 PM
Raymundus Re: Split datetime to date... 02-05-2016, 05:53 PM
  1. 02-05-2016, 05:36 PM #1
    mdek is offline
    Registered User
    Join Date
    01-15-2016
    Location
    englanf
    MS-Off Ver
    2007
    Posts
    42

    Split datetime to date and time

    Hi

    I have a sheet with datetime in one cell, now i want to split it date and time seperate.

    Can this in VBA?
    Reply With QuoteRegister To Reply
  2. 02-05-2016, 05:42 PM #2
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Split datetime to date and time

    Can you use TextToColumns? Convert your cell to Short Date format and use Text To Columns to separate Date and Time.
    Attached Files Attached Files
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
  3. 02-05-2016, 05:50 PM #3
    mdek is offline
    Registered User
    Join Date
    01-15-2016
    Location
    englanf
    MS-Off Ver
    2007
    Posts
    42

    Re: Split datetime to date and time

    The field is a datetime field, it comes from a database, the split has to be done very ofter so a macro is best i think
    Reply With QuoteRegister To Reply
  4. 02-05-2016, 05:53 PM #4
    Raymundus is offline
    Registered User
    Join Date
    01-15-2016
    Location
    Dallas, TX
    MS-Off Ver
    2007
    Posts
    65

    Re: Split datetime to date and time

    You will find this link useful...

    http://www.laurii.info/2012/10/vba-s...e-time-column/
    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. Split datetime to date and time
    By mdek in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2016, 05:54 PM
  2. [SOLVED] split day from date time
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2014, 03:20 PM
  3. [SOLVED] reference date time range, return the value into all cell that match datetime range
    By Jarvco13 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-22-2013, 10:39 PM
  4. Excel 2007 : DateTime Difference with Military Date/time
    By SalemPoe in forum Excel General
    Replies: 5
    Last Post: 10-28-2010, 03:24 PM
  5. 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
  6. Split Date and Time
    By aftabn10 in forum Excel General
    Replies: 3
    Last Post: 09-09-2008, 04:59 AM
  7. Split date and time
    By Warsteiner in forum Excel General
    Replies: 2
    Last Post: 12-08-2005, 06:15 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