Hi guys I'd appreciate some help.

I have a spreadsheet containing the time complaints were received. About 9000 entries are in the 24 hr format (e.g. 12:34), but about 1000 are not and are recorded as single or double digits without the colon (e.g 12 instead of 12:00).
How can I covert all numbers to the same 24hr format?

Thanks jo