Time Format Auto Entry AM and PM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The default time format is AM. I would like to create a format for cells that
will only have PM entries. When someone writes 2:00, it will automatically
upon exiting cell create 2:00 PM. I've looked in help and tried alterations
of the General Time Format - No Luck. Is this a can do? BULAMAN
 

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

Creating uniform time format from multiple formats 1
Excel Catagorise AM or PM 7
Time formatting in Excel 2003 2
Separate AM/PM from time. 2
Input Time in AM/PM 3
AM / PM Cells 3
Comparing Time in a Formula 1
Grouping Time in Pivots. 2

Back
Top