Time input mask format

[WNB-96740]

If I input - "340 a", I want it to show "3:40 AM"

or if I input 1230 p, I want it formated as 12:30 PM

can this be done?

 

[Rich]

enter your times as 3:40 or 12:30 and set the format of the cell to show
it as am or pm

format ,,,, cells,,,,custom,,, h:mm AM/PM

 

[Gord Dibben]

There is no way to set up an input mask as you describe without using VBA.

See Chip Pearson's site for quickentry dates and times.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben Excel MVP