Forum Discussion
Need Help Sorting This Date/Time Column
Without helper cells, a succinct alternative would be this formula in H3 of mathetes's file:
=--REPLACE(A3,1,FIND(",",A3)+1,"")
With H3 formatted like G3, the result of the foregoing formula looks like this:
Thank you for the work you put into that. However, with the time striped out, the text messages might be sorted by the date but the time of when they were sent will no longer be in order since they are no longer being sorted by both date and time. Twifoo
The time is still there. Cell H3 didn't show the time simply because the custom format didn't include it. If cell H3 is custom-formatted as "mmmm d, yyyy h:mm:ss AM/PM", then it would also show the time like this:
GetAKitty4465 Sorry, from your original post it looked like you were just looking for the date to be the basis for the sorting.
Here's the same spreadsheet as before, but with an additional column that just contains the Time Value in a sortable form. Add it to the spreadsheet and sort first by Date, then by Time (all in one sort; just sequence the fields in that order)
