| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Times In Excel
I currently use Office 2003. Is there a format i can set up for cells where i
can type in just 4 characters for a time, say 0845 for 8:45 AM without having to type in the : colon or the "AM". I have set up formats for numbers generally, but can't seem to get this working. I have a column for AM times, and another for PM times, so there could be two formats, one for each column. Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| colour formatting does not show on screen at all times | Excel Discussion (Misc queries) | |||
| Formatting values to be Times of day... | Excel Discussion (Misc queries) | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
| How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
| Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Threaded Mode
