LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 85
Default "h:mm" format, but 12-hour time, not 24-hour time?

Ostensibly, I would like to use the format "h:mm", which does not
display AM or PM. But I want it to always display 12-hour time,
ignoring AM and PM, not 24-hour time.

Is there a format (standard or custom) that will do that
automagically, without my resorting to a formula?

(I am using Excel 2003.)

If I enter 10:00 in one cell and drag down, the time after 12:00 is
13:00. I want 1:00, just as I would get if I used the format "h:mm AM/
PM". (But of course, that includes the AM or PM suffix, which I do
not want.)

To get what I want, I have to manually change 13:00 to 1:00, then
start dragging down again.

That's a drag :-).
 
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
0100 (24 hour) time - Which format?? MikeR-Oz New Users to Excel 3 May 12th 08 06:52 AM
display time in 12 hour format jatman Excel Worksheet Functions 1 March 20th 08 06:10 AM
how to get "day/night" from a cell of time/hour kbee Excel Worksheet Functions 3 February 13th 08 05:48 AM
24 hour time format help with 00:00 calculation Pogo Excel Discussion (Misc queries) 9 July 22nd 06 01:09 PM
Convert decimal hour into time format? ramdalen Excel Discussion (Misc queries) 2 June 20th 05 06:21 PM


All times are GMT +1. The time now is 12:33 AM.

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"