Easily Create A Sequence Of Regularly Spaced Time Intervals In Excel


Say you need to create regular appointment slots for a doctors surgery from 8 am to 12 noon, or times for interviewing job applicants. It’s really easy to auto create a list of available appointments with the Excel Auto Fill feature.

All you need to do is enter your first two appointments, in this case in cell A3 and A4 I enter 8 am and 8:10 am respectively, then use auto fill (just move the cursor to the lower right corner of the cell A4 until you see the black cross then drag the pointer down until you reach 12 noon).

1274376

Excel will recognize the intervals you are auto filling and carry on the sequence until you stop.

Easy as that!

 

 

 

 

 

 

 

 

More Excel Tips

 

Find and replace line breaks in Excel

Excel autofill with Weekdays only

Add a Word document into Excel

Move or copy worksheets between workbooks in Excel

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts