 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008sort not working properly ?
Is there a way to get the list below to sort in time sequence? Notice that the morning times are after the PM times on Friday. You are looking at 3 columns here. date, hyphen and time. Time column is formatted as time. Sort is in ascending order, what is wrong here? 4-24-Thu - 7:30 PM 4-25-Fri - 6:00 PM 4-25-Fri - 8:00 PM 4-25-Fri - 8:00 PM 4-25-Fri - 8:00 PM 4-25-Fri - 8:00 PM 4-25-Fri - 9:00 AM 4-25-Fri - 10:30 AM 4-25-Fri - 12:00 PM 4-26-Sat - 11:00 AM Try place the sort in the time colum instaead of date colum? maybe I am not sure though > Is there a way to get the list below to sort in time sequence? > Notice that the morning times are after the PM times on Friday. [quoted text clipped - 11 lines] > 4-25-Fri - 12:00 PM > 4-26-Sat - 11:00 AM Hi Larry, Perhaps the time column is not formatted as time. It seems to be sorting as text. Check the format used in that column. Regards - Dave. You can check the format, but that doesn't tell you if it is text. The ISTEXT() function will. You can convert to real Excel time with the TIMEVALUE() function. Use the date as first sort key and the time as second.  SignatureKind regards, Niek Otten Microsoft MVP - Excel | Hi Larry, | Perhaps the time column is not formatted as time. It seems to be sorting as | text. | Check the format used in that column. | Regards - Dave. The sort is working properly. Sorting ascending: 4-25-Fri - 8:00 PM preceds 4-25-Fri - 9:00 AM as 8 preceds 9 in an ascending sort. In your case, you seem to have text, not Excel date/time values. The sort is done by evaluating the contents from left to right. If you have true Excel date/times, and you sort, then format as date/times, the results will be in the sequence you want with AM preceding PM. You're confusing formatting of cells with the contents of cells. Tyro > Is there a way to get the list below to sort in time sequence? > Notice that the morning times are after the PM times on Friday. [quoted text clipped - 11 lines] > 4-25-Fri - 12:00 PM > 4-26-Sat - 11:00 AM Thanks, Turns out the ones that were not sorting properly were text! Thanks again
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.