Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
how do i make a column for time read as a 24 hour entry.Example (time)column
in this column i want to type time but in the 24 hour format and have it stay there in the column |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
So what's your problem? If I type 14:00 in a cell that's what I see.
If you mean what is seen in the formula bar then you need to change the regional settings of your OS to 24 hour HH:mm -- Regards, Peo Sjoblom "dukeduke" wrote in message ... how do i make a column for time read as a 24 hour entry.Example (time)column in this column i want to type time but in the 24 hour format and have it stay there in the column |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"h:mm" format, but 12-hour time, not 24-hour time? | Excel Discussion (Misc queries) | |||
Changing decimal time into 24 hour time and reverse | Excel Discussion (Misc queries) | |||
how can i add an hour to a time column | Excel Worksheet Functions | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
How do I make an important instruction cell flash in Excel? | Excel Discussion (Misc queries) |