Challenge with Time Formatting - want to include AM or PM

  • Thread starter Thread starter Val B.
  • Start date Start date
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Catagorise AM or PM 7
Separate AM/PM from time. 2
Input Time in AM/PM 3
Time formatting in Excel 2003 2
AM/PM Format 6
Excel Convert Datetime Stamp to HH and MM Worked 7
default time to PM after 12:00 pm 4
If Question 2

Back
Top