I'm trying to convert a column showing the time of road traffic accidents from military time to standard time. The data looks like this:
Col1 Time..24hr.
1 1404
2 322
3 1945
4 1005
5 945
I'd then like to convert to 12hr so for '322' I'd like to make '3', for instance. Thanks a lot