![]() |
instruction on how to make a 24 HOUR TIME COLUMN
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 |
instruction on how to make a 24 HOUR TIME COLUMN
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 |
All times are GMT +1. The time now is 11:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com