Thank you! I thought I was doing it that way, (but the time increments were
wrong, and there were no skipped rows) but I finally figured out what I was
doing wrong. Not only that, but the time format came out right, as well. I
appreciate your help. Regards, S



"JE McGimpsey" wrote:

One way:

AutoFill:



A1: 6:00 AM
A2: <leave blank
A3: 6:30 AM
A4: <leave blank

Select A1:A4. Drag the fill-handle (lower right-hand corner of A4) down
as far as required.

In article ,
XLXPertWannabe wrote:

I'm trying to teach myself Excel XP (using "...for Dummies"). I used
Autofill to create a daily time schedule column, but in alternating cells
(e.g., 6:00 AM/[empty cell/6:30 AM/[empty cell]. Is this an Autocomplete or
Autofill function? Also, it uses military time. How do I get 12-hour time?
Thank you.