Results 1 to 3 of 3

separating date and time from one cell to two

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    Denver, CO
    MS-Off Ver
    Excel 2007
    Posts
    2

    separating date and time from one cell to two

    I have a timepoint in one cell and I would like to separate the date and time into two cells so it is easier to filter. Below is an example of the data. This example would be the equivalent of 3 cells. How can I get this data to have the date in one cell and then the time next to it in a different cell? i have also attached a sample file for clarity.

    11/1/2006 17:00
    11/1/2006 18:00
    11/1/2006 19:00
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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