Challenge with Time Formatting - want to include AM or PM

V

Val B.

Hi! Column A displays like this: 11:48:52. Column B
displays AM. When I try to get column A to display with
am or pm it converts the time to 12:00:00. I am not sure
where the data is coming from, but it is being imported
with this data as two seperate fields. Any suggestions??
Thanks!
 
Top