Good day!

I have 2 columns one for timein and one for timeout...and the data is from uploaded .xml file, my problem now is the saving of timeout in database..

in my .xml file I have this data:

Emp no Time In Time Out
100603 10/1/11 7:30 AM 10/1/11 6:00 PM
100603 10/2/11 8:00 AM 10/2/11 6:30 PM


and it saves in db
Emp no Time In Time Out
100603 2011-10-01 07:30:00 2011-10-01 18:00:00
100603 2011-10-02 08:00:00 2011-10-01 18:30:00

I want the timein and time out is formatted in 12 hours. As you can see the time out is formatted in 24 hours.

Thank you...