Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 964
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"h:mm" format, but 12-hour time, not 24-hour time? [email protected] Excel Discussion (Misc queries) 5 September 2nd 08 10:54 AM
Changing decimal time into 24 hour time and reverse Bobzter100 Excel Discussion (Misc queries) 4 January 25th 08 11:38 AM
how can i add an hour to a time column Sarah P Excel Worksheet Functions 1 February 24th 07 08:02 AM
how to calculate time start & time finish in quarter hour Peter Wu Excel Discussion (Misc queries) 3 June 7th 06 12:58 AM
How do I make an important instruction cell flash in Excel? Bil Stewart Excel Discussion (Misc queries) 2 November 27th 05 05:37 PM


All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"