| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel time format
How can i format a cell that will display the ime as 08:00 when i enter 8? i
have tried using the format hh:mm but when i enter 8 the cell displays 00:00:00 and the formula bar shows 08/01/1900 00:00:00. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel time format
see
http://cpearson.com/excel/DateTimeEntry.htm In article , JarvisC wrote: How can i format a cell that will display the ime as 08:00 when i enter 8? i have tried using the format hh:mm but when i enter 8 the cell displays 00:00:00 and the formula bar shows 08/01/1900 00:00:00. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel time format
Many thanks, works a treat!
"JE McGimpsey" wrote: see http://cpearson.com/excel/DateTimeEntry.htm In article , JarvisC wrote: How can i format a cell that will display the ime as 08:00 when i enter 8? i have tried using the format hh:mm but when i enter 8 the cell displays 00:00:00 and the formula bar shows 08/01/1900 00:00:00. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel time format
If I understand this right I have to write a macro to the the time to display
the way I want? i.e. 8 = 8:00? "JE McGimpsey" wrote: see http://cpearson.com/excel/DateTimeEntry.htm In article , JarvisC wrote: How can i format a cell that will display the ime as 08:00 when i enter 8? i have tried using the format hh:mm but when i enter 8 the cell displays 00:00:00 and the formula bar shows 08/01/1900 00:00:00. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel time format
You don't have to write the macro.
Chip has done that for you. Gord Dibben MS Excel MVP On Wed, 29 Jul 2009 05:44:01 -0700, Hezzy wrote: If I understand this right I have to write a macro to the the time to display the way I want? i.e. 8 = 8:00? "JE McGimpsey" wrote: see http://cpearson.com/excel/DateTimeEntry.htm In article , JarvisC wrote: How can i format a cell that will display the ime as 08:00 when i enter 8? i have tried using the format hh:mm but when i enter 8 the cell displays 00:00:00 and the formula bar shows 08/01/1900 00:00:00. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| Excel charts should have format templates | Charts and Charting in Excel | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
| Excel Time Manipulation | Excel Discussion (Misc queries) | |||
| Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
Linear Mode
