View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
XLXPertWannabe XLXPertWannabe is offline
external usenet poster
 
Posts: 6
Default Autofill time schedule with gaps

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.