Hi George,

If you put 1:00 in a cell and then drag down 12 cells,
release the fill handle and then grab it again and drag
down as far as needed, hold down Ctrl, release the fill handle,
then release Ctrl.

You will have a repeating series of 1:00 to 12:00
which are actually all AM times.

Is that the sort of effect you are looking for?

HTH
Martin



wrote in message
...
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 :-).