# How can I sort a column of military times from earliest to latest?

1. ## How can I sort a column of military times from earliest to latest?

I have a column with military times that I would like to sort from the earliest time to the latest time and also sort the column next to it with it.

The earliest time on the list is 1:15 with M next to it in the next column. I'd like to keep the letters next to each time. And also, how can I get it to ignore blank cells in the column and just any cell that doesn't contain military time format?

I have attached an example.

Thanks.

2. ## Re: How can I sort a column of military times from earliest to latest?

There are instructions at the top of the page explaining how to attach your sample workbook.

3. ## Re: How can I sort a column of military times from earliest to latest?

I didn't want to include the whole thing.

4. ## Re: How can I sort a column of military times from earliest to latest?

From the instructions to which I pointed:

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) ...

5. ## Re: How can I sort a column of military times from earliest to latest?

Is a table good enough?

6. ## Re: How can I sort a column of military times from earliest to latest?

No. We need to see the way that the data is formatted.

I don't understand why you think it's hard to post a workbook containing a small sub-set of your real data. It would save so much guesswork.

7. ## Re: How can I sort a column of military times from earliest to latest?

Have attached an example of what I'm talking about.

8. ## Re: How can I sort a column of military times from earliest to latest?

Try

=INDEX(A\$1:A\$22,MATCH(SMALL(\$A\$1:\$A\$22,ROWS(\$1:1)),\$A\$1:\$A\$22,0))

Copy across and down

9. ## Re: How can I sort a column of military times from earliest to latest?

I selected columns A and B, then went to the Data ribbon and clicked the button to sort A to Z. Is this what you want?

AliGW on MS365 Insider (Windows) 32 bit
A
B
1
01:15
M
2
01:30
Q
3
02:20
O
4
04:10
N
5
04:55
P
6
15:25
F
7
16:10
C
8
16:35
G
9
16:45
D
10
16:53
I
11
17:14
A
12
17:45
H
13
17:55
E
14
18:10
K
15
18:24
B
16
18:38
J
17
20:05
L
18
21:41
R
19
20
21
22
 Sheet: Sheet1

10. ## Re: How can I sort a column of military times from earliest to latest?

Seems to work now. Thanks.

11. ## Re: How can I sort a column of military times from earliest to latest?

Select B5 to I26.

Data | Sort | Time (from drop-down) - smallest to largest.

AliGW on MS365 Insider (Windows) 32 bit
A
B
C
D
E
F
G
H
I
5
Date: RM RN Time: NOH DSFLR FPLR MBW FN
6
01/07/2020
Greyville
7
01:15
12
19
2
0.05
Bhakka
7
Tipperary
4
01:30
12
6
1
NA Lord Lariat
8
Musselburgh
7
02:20
9
17
2
0.75
9
Kempton Park
2
04:10
12
11
1
NA Tommy Rock
10
Leopardstown
4
04:55
12
7
1
NA Reverberation
11
Randwick Kensington
2
15:25
8
15
2
0.5
Jimmy's Dream
12
Sandown Lakeside
4
16:10
8
15
1
NA Grand De Flora
13
Randwick Kensington
4
16:35
8
15
2
2
Darleb
14
Sandown Lakeside
5
16:45
10
15
3
0.8
Maximak
15
Doomben
5
16:53
8
20
1
NA Merlin's Magic
16
Belmont
2
17:14
12
15
2
2.69
Convalesce
17
Randwick Kensington
6
17:45
10
19
1
NA Le Gai Soleil
18
Sandown Lakeside
7
17:55
13
11
2
2.25
Seas No Limit
19
Balaklava
7
18:10
13
15
1
NA Kahaylaan
20
Belmont
4
18:24
11
15
1
NA Avalon Bay
21
Doomben
8
18:38
13
12
3
1.3
Roman Aureus
22
Sha Tin
7
20:05
10
18
2
0.1
Mig Energy
23
Redcliffe
5
21:23
8
7
1
NA Tinka Terror
24
Bathurst
5
21:41
9
8
3
1.1
Sammi Dance
25
Redcliffe
6
21:53
8
7
3
3
Storm Gilbert
26
Bathurst
6
22:11
10
9
3
4.3
My Buzz Lightning
 Sheet: Sheet1

12. ## Re: How can I sort a column of military times from earliest to latest?

Thanks for marking the thread as solved.

You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

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