>>>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.
You mean about Military Time not having colons?
Doesn't seem relevant, since the source data in Jay's sample had the colon in it, providing a solution that was for data without colons would not be very helpful.
BTW from what I can see although 2400 is in common use casually the correct military notation for it is 0000.