I have a column with a bunch of two 4 digits. 

1. 1354 1356
2. 1402 1421
3. 1431 1452
4. 1532 1546
... and so on

I've been trying to convert these to look more like

1. 13:54 ~ 13:56
2. 14:02 ~ 14:21
3. 14:31 ~ 14:52
4. 15:32 ~ 15:46
...

I've tried wildcard but it's too simple to handle that. I couldn't find a function nor was I successful with date/time format. I'm not sure if I should learn VBA for that.