| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert spinning button with time format in Excel 2000? | Excel Discussion (Misc queries) | |||
| Locking The Cells with Input At The Time of Saving The File | Excel Discussion (Misc queries) | |||
| Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
| I cannot get time format to display in a drop-down list | Excel Discussion (Misc queries) | |||
Linear Mode
