convert time without am pm to 24 hr

[slochin]

Hello,
I have a sheet I download daily with among other data a time in colA. This does not have am or pm.
So examples are below. This is for a sporting event and the times start in the mid morning.There would not be any late night times such a 12:00 midnight or 12:30 (AM) in the morning. I would like to be able to convert this to 24 hr time in the format which would keep the first three as the same and then 1:00 becomes 13:00 and so on.Hoping someone can help please.
10.30
12:00
12:30
1:00
1:30
[TABLE="width: 98"]
<colgroup><col></colgroup><tbody>[TR]
[TD]7:15


[/TD]
[/TR]
</tbody>[/TABLE]

 

[fhqwgads]

what's the earliest and latest times you will get?

 

[slochin]

Hello,
Thanks for reply. Does vary but mainly between 9am in the morning and 11pm at night

 

[fhqwgads]

maybe like this?

Book1
	E	F
10	7:30	07:30
11	8:00	08:00
12	8:30	08:30
13	9:00	09:00
14	9:30	09:30
15	10:00	10:00
16	10:30	10:30
17	11:00	11:00
18	11:30	11:30
19	12:00	12:00
20	12:30	12:30
21	1:00	13:00
22	1:30	13:30
23	2:00	14:00
24	2:30	14:30
25	3:00	15:00
26	3:30	15:30
27	4:00	16:00
28	4:30	16:30
29	5:00	17:00
30	5:30	17:30
31	6:00	18:00
32	6:30	18:30
33	7:00	19:00
34	7:30	07:30
Sheet28

Cell Formulas
Range	Formula
F10	=TEXT(IF(E10<0.3125,E10+0.5,E10),"hh:mm")

 

[fhqwgads]

ah sorry i didnt read your edit before i posted
my formula just adds on 12 hours to the time if it was before 7:30am making it look like pm in 24hour time. that wont work for times that are between 9am and 11pm since if i change it to before 11pm it would include times between 9am and 11am that are actually am and not pm

EDIT: basically the problem i've run into is if you can get times in the data that are 10am and 10pm but it will show 10:00 for both, i can't think of anyway to differentiate the two

sorry i couldnt help