>>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


Nope... see reply to Naomi.