>>>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 ))
>>>
>>
>>Forest for the trees kinda thing? Maybe you should consider Miller time instead! :)
>>
>>Start with this and add am/pm or what have you.
>>?Normaltime("13:45")
>>
>>NORMALTIME.PRG
>>LPARAMETERS m.tcTime
>>LOCAL m.lnHours, m.lcHours, m.lcMinutes
>>lnColon = AT(":",m.tcTime)
>>m.lnHours = val(LEFT(m.tcTime,m.lnColon-1))
>>m.lcHours = right("0"+str(iif(m.lnHours>12,m.lnHours-12,m.lnHours)),2)
>>m.lcMinutes = SUBSTR(m.tcTime,m.lnColon)
>>RETURN m.lcHours + m.lcMinutes
>
>
>Hi Mike:
>
>Your function does not return the correct value if you plug in the military time '0001' or '00:01' 24:30 is not military time, 0030 is. 2400 is only used to represent midnight. Midnight + 1 minute is 0001 hours.
I didn't know that. I'm not in the military. ;)