>How can I convert the following to non-military time? And yes, before the jokes start, the "13:45" is a value in an array. I can't just retype it to "1:45" instead. Thanks!
>
>
>(RIGHT( "0" + ALLTRIM( "13:45" ), 5 ))
>
Hilmar and Naomi gave you the correct answer, but if you just need a quick and dirty solution and your system is set to 12 hour time you can do this:
RIGHT(TTOC(CTOT("13:45")),11)
It gets 00:00 correctly but not 24:00