Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i type a time into a cell formatted for time?
I have highlighted a block of cells and used format-cell-time to format for
time but when I try to type in a time using the 24 hr clock eg. 0800 it converts the time to a date. What am I ding wrong? |
#2
|
|||
|
|||
You're doing nothing wrong - except for Text (which bypasses XL's entry
parser), the display format has no effect on how an entry is parsed. For a way to accomplish what you're after, see http://cpearson.com/excel/DateTimeEntry.htm In article , Armadillo wrote: I have highlighted a block of cells and used format-cell-time to format for time but when I try to type in a time using the 24 hr clock eg. 0800 it converts the time to a date. What am I ding wrong? |
#3
|
|||
|
|||
You need the colon, 08:00
-- HTH RP (remove nothere from the email address if mailing direct) "Armadillo" wrote in message ... I have highlighted a block of cells and used format-cell-time to format for time but when I try to type in a time using the 24 hr clock eg. 0800 it converts the time to a date. What am I ding wrong? |
#4
|
|||
|
|||
On Thu, 16 Jun 2005 09:53:02 -0700, Armadillo
wrote: I have highlighted a block of cells and used format-cell-time to format for time but when I try to type in a time using the 24 hr clock eg. 0800 it converts the time to a date. What am I ding wrong? You are missing the concept that formatting the cell for time only affects how the contents of the cell are DISPLAYED. The format has nothing to do with how Excel parses your entry. You either have to add the colon when you type, eg: 08:00, or somehow convert 0800 to an Excel time. One method of converting the 24 hr times into "Excel times" is to use this formula in an adjacent cell: =--TEXT(A1,"00\:00") and ensure the cell with this formula IS formatted as time. --ron |
#5
|
|||
|
|||
Enter the time as 0:08:00?
"Armadillo" wrote: I have highlighted a block of cells and used format-cell-time to format for time but when I try to type in a time using the 24 hr clock eg. 0800 it converts the time to a date. What am I ding wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to know that character type in one cell of xls is more that s. | Excel Discussion (Misc queries) | |||
Can I set the numerical type of Cell to Hex format | Excel Discussion (Misc queries) | |||
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) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |