Elegant way to convert table of times to 24-hour format?
I have a rather large table one column of which contains times in
12-hour format without the colon: 642a, 1009p, etc. (no seconds)
Can anyone think of a clever way to convert that column to standard
24-hour format: 06:42:00, 20:09:00, etc.?
|