Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date and Time Sorts (Excel 2003 SP3)

    Trying to figure out a way to sort appointments by date then time (am first, then pm on same date). The time displays as military time in the column and am/pm time in the formula bar. Do you know of a way to sort by time in chronological order by date and display with am/pm time in the column? Sorting with am/pm doesn't produce the right result. Carol

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Date and Time Sorts (Excel 2003 SP3)

    I would put the date and time together in 1 column. If they are both serial date/times you can just add the 2 together then delete the individual columns. The single column can be formatted (via format - cells) to display both date/time (custom format (no quotes): "mmm d, yyyy hh:mm am/pm").

    Then you can sort with this column.

    Steve

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date and Time Sorts (Excel 2003 SP3)

    If "time displays as military time in the column and am/pm time in the formula bar", then that indicates that those values are Excel Date Time values. However, you haven't told us anything that we can use to determine if those values also contain the date. If those values do not contain the date, then they will sort in order without reguard to which date they fall on. Are the dates by chance in a different column. You could save us all a lot of time trying to figure out what you have if you would upload the workbook. You can delete everything but the column or columns that contain the dates and times.
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date and Time Sorts (Excel 2003 SP3)

    I'm sorry about the lack of date information. The date is in one column and the time in another. We sort by date, then time.

  5. #5
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date and Time Sorts (Excel 2003 SP3)

    That works great---thanks so much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •