Time input mask format
 

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?

Time input mask format
 

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


"WNB-96740" wrote:

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?

Time input mask format
 

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

On Thu, 15 Dec 2005 18:09:02 -0800, WNB-96740
wrote:

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?