I'm trying to Export from an OLD System that stored Time in / Time out as a text string in 24 hour time.
For example 3pm, is entered as 1500 (no colon)
Is there a simple way I can convert these Values to a 12 Hour time with AM / PM?
I've got over 3000 entries - and I'm almost to the point of manually editing, so please any suggestions are appreciated.