Excel Question! Adding 5 min intervals to a start time?

Question

I want to make a chart that starts at 8:00 AM and then increases in five minute intervals until 5:00 PM. 8:00, 8:05, 8:10, etc. I can only figure out how to total times. That is not what I want! I want to drag down the corner and make a list! Any ideas?

Additional Details

Thanks Jake!

Answer 1

Best Answer - Chosen by Asker

In the first three cells, type 8:00, 8:05, and 8:10. Then highlight these cells (not the drag down thing yet, only select them). NOW, click the teeny box at the bottom right and drag down.

It will automatically increment the times for every 5 minutes. :)

Asker's Rating:

Asker's Comment:

Thanks for your fast answer

Answer 2

Format the 'A' column "Time" & then select "1:30 PM"
A1 - 8:00
A2 - 8:05
Place the cursor in A1 & drag to A2
Then drag the bottom RH corner of A2

ÕÕ
<
~