Results 1 to 17 of 17

Date & Time in the same column, needs sorting

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-04-2013
    Location
    Bucharest
    MS-Off Ver
    Office Professional Plus 2019
    Posts
    304

    Date & Time in the same column, needs sorting

    Hello,
    I hope this one's going to be easy.
    Let's take the G column for example. The database I'm working with is generated automatically so I can't help but have the time and date in a single column. The problem is I need to sort the column chronologically or counter-chronologically,and Excel doesn't even see the cells as time or date, I've tried formatting the column but no luck. So I hoped there's an easy way around this. Keep in mind that the actual database is tens of thousands of rows, not sure it's relevant but..
    Thanks !
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. extract time from date/time for sorting
    By always Stumped in forum Excel General
    Replies: 3
    Last Post: 01-22-2015, 08:20 PM
  2. Replies: 12
    Last Post: 01-28-2014, 12:36 PM
  3. [SOLVED] Need help sorting a field with date and time
    By mnhim001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-19-2013, 01:14 AM
  4. Sorting the Date and Time
    By qwert2001 in forum Excel General
    Replies: 4
    Last Post: 01-03-2013, 10:45 PM
  5. Sorting a dataset with another using date and time
    By Matt Guernsey in forum Excel General
    Replies: 1
    Last Post: 07-22-2010, 08:29 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1