ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   instruction on how to make a 24 HOUR TIME COLUMN (https://www.excelbanter.com/excel-worksheet-functions/201034-instruction-how-make-24-hour-time-column.html)

dukeduke

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

Peo Sjoblom[_2_]

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