How do I sort these dates correctly?

[thepartydj]

These dates and time will not sort in the correct order. The column is set to date, but it is not working. Please help. Thanks!

Jan 18, 2023 7:10am

Jan 19, 2023 10:23pm

Jan 19, 2023 3:11pm

Jan 19, 2023 3:12pm

Jan 19, 2023 5:00pm

Jan 19, 2023 5:25pm

Jan 19, 2023 5:29pm

Jan 19, 2023 5:29pm

Jan 2, 2023 5:08am

Jan 2, 2023 5:27am

Jan 2, 2023 5:41am

Jan 2, 2023 5:41am

Jan 2, 2023 5:47am

Jan 20, 2023 11:01am

Jan 20, 2023 5:05am

Jan 21, 2023 12:25am

Jan 3, 2023 5:01pm

Jan 3, 2023 5:39pm

Jan 3, 2023 5:40pm

Jan 3, 2023 6:22pm

Jan 3, 2023 8:02pm

Jan 3, 2023 8:02pm

Jan 3, 2023 8:03pm

Jan 3, 2023 8:04pm

Jan 3, 2023 8:04pm

Jan 3, 2023 8:04pm

Jan 3, 2023 8:05pm

Jan 3, 2023 8:05pm

Jan 4, 2023 10:50pm

 

[etaf]

they are not dates - they are text

if you format the column to general - they should all change to a number - (days from 1900)

try using DATA> text to columns and see if that changes correctly to a date format

 

[thepartydj]

they are not dates - they are text

if you format the column to general - they should all change to a number - (days from 1900)

try using DATA> text to columns and see if that changes correctly to a date format

Looks like it is all text. Text to column doesn't change and format doesn't change the fact that it is just text. Do I need to move the time to a different column and then try to sort? Can you help how I would do that?

 

[Sufiyan97]

Try replacing "AM" with " AM" and "PM" with " PM"

 

[etaf]

i had to use
=DATEVALUE(MID(A1,4,2)&" "&LEFT(A1,3)&" "&TRIM(MID(A1,8,5)))+TIMEVALUE(MID(A1,SEARCH(":",A1,1)-2,2)&":"&MID(A1,SEARCH(":",A1,1)+1,2)&" "&RIGHT(A1,2))

Book4
	A	B
1	Jan 18, 2023 7:10am	01/01/2023 7:10 am
2	Jan 19, 2023 10:23pm	01/01/2023 10:23 pm
3	Jan 19, 2023 3:11pm	01/01/2023 3:11 pm
4	Jan 19, 2023 3:12pm	01/01/2023 3:12 pm
5	Jan 19, 2023 5:00pm	01/01/2023 5:00 pm
6	Jan 19, 2023 5:25pm	01/01/2023 5:25 pm
7	Jan 19, 2023 5:29pm	01/01/2023 5:29 pm
8	Jan 19, 2023 5:29pm	01/01/2023 5:29 pm
9	Jan 2, 2023 5:08am	02/01/2023 5:08 am
10	Jan 2, 2023 5:27am	02/01/2023 5:27 am
11	Jan 2, 2023 5:41am	02/01/2023 5:41 am
12	Jan 2, 2023 5:41am	02/01/2023 5:41 am
13	Jan 2, 2023 5:47am	02/01/2023 5:47 am
14	Jan 20, 2023 11:01am	02/01/2023 11:01 am
15	Jan 20, 2023 5:05am	02/01/2023 5:05 am
16	Jan 21, 2023 12:25am	02/01/2023 12:25 am
17	Jan 3, 2023 5:01pm	03/01/2023 5:01 pm
18	Jan 3, 2023 5:39pm	03/01/2023 5:39 pm
19	Jan 3, 2023 5:40pm	03/01/2023 5:40 pm
20	Jan 3, 2023 6:22pm	03/01/2023 6:22 pm
21	Jan 3, 2023 8:02pm	03/01/2023 8:02 pm
22	Jan 3, 2023 8:02pm	03/01/2023 8:02 pm
23	Jan 3, 2023 8:03pm	03/01/2023 8:03 pm
24	Jan 3, 2023 8:04pm	03/01/2023 8:04 pm
25	Jan 3, 2023 8:04pm	03/01/2023 8:04 pm
26	Jan 3, 2023 8:04pm	03/01/2023 8:04 pm
27	Jan 3, 2023 8:05pm	03/01/2023 8:05 pm
28	Jan 3, 2023 8:05pm	03/01/2023 8:05 pm
29	Jan 4, 2023 10:50pm	04/01/2023 10:50 pm
Sheet2

Cell Formulas
Range	Formula
B1:B29	B1	=DATEVALUE(MID(A1,4,2)&" "&LEFT(A1,3)&" "&TRIM(MID(A1,8,5)))+TIMEVALUE(MID(A1,SEARCH(":",A1,1)-2,2)&":"&MID(A1,SEARCH(":",A1,1)+1,2)&" "&RIGHT(A1,2))

 

[thepartydj]

I ended up using text to columns to split the month-day and time. Then I formated Month-day to date, and time to time and left them seperate.