<crjunk@earthlink.net> wrote in message
news:1143057251.791124.244730@e56g2000cwe.googlegroups.com...
> I'm working with a table that has a field that stores time values as a
> string. The time values are in military time (such as 13:30).
>
> How can I have 13:30 displayed as 01:30 PM in my datagrid? Can I use
> DataFormatString to achieve this?
>
> Thanks,
> CR Junk
>

Elton Wang wrote:
> Try
>
> DataFormatString ={0: HH:mm tt}
> or
> DataFormatString ={0: hh:mm tt}
>

<crjunk@earthlink.net> wrote in message
news:1143124935.818499.84510@i40g2000cwc.googlegroups.com...
>
> Elton Wang wrote:
>> Try
>>
>> DataFormatString ={0: HH:mm tt}
>> or
>> DataFormatString ={0: hh:mm tt}
>>
>
> Hi Elton,
>
> I tried using both of your suggestions, but they seem to have no effect
> on the formatting of the data in the datagrid. Any other suggestions?
>
> Thanks,
> CR Junk
>