| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
cell assumes wrong date
I want to format a cell for time. I want to type "0830" in a cell and have it
show 8:30 AM. So I format the cell accordingly. But when I type 0830 in the cell I get "12:00 AM", and if I double click into the cell it shows "4/9/1902 12:00:00 AM". What can I do to have it not include a date...just a time? |
|
#2
|
|||
|
|||
|
You can't unless you use a macro, see:
http://www.cpearson.com/excel/DateTimeEntry.htm One day is 1, one hour is 1/24 no formatting can change 830x24 hours into 08:30, you need the above macro Regards, Peo Sjoblom "julie from Seattle" wrote: I want to format a cell for time. I want to type "0830" in a cell and have it show 8:30 AM. So I format the cell accordingly. But when I type 0830 in the cell I get "12:00 AM", and if I double click into the cell it shows "4/9/1902 12:00:00 AM". What can I do to have it not include a date...just a time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date format within a cell containing a formula | Excel Discussion (Misc queries) | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Hybrid Mode
