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? |
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? |
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? |
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 |
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? |
All times are GMT +1. The time now is 02:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com