Results 1 to 16 of 16

How to Sort or filter Date/Time data

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2013
    Location
    use
    MS-Off Ver
    Excel 2010
    Posts
    9

    How to Sort or filter Date/Time data

    Hello-
    I am attempting to sort a large amount of data(400k inputs) by time. However the way it is sent to me is with the date and time together in one cell.
    ie. DateTime
    4/5/2011 9:36
    4/5/2011 9:43
    4/5/2011 9:52
    4/5/2011 10:01
    4/5/2011 10:02
    4/5/2011 10:06
    4/5/2011 10:38

    I am looking to sort the data so I see only the data between 10:15 and 3:45....

    I am very confused on how to do this. I can not get the date and time broken out into separate columns, which would make this much easier.

    Thanks in advance.
    Last edited by TheWookie; 04-01-2013 at 07:09 AM.

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