Time Format Auto Entry AM and PM
 

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

Hi
I think you'll need VBA. See:
http://www.cpearson.com/excel/DateTimeEntry.htm

--
Regards
Frank Kabel
Frankfurt, Germany

BulaMan wrote:
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