How to auto fill cells in half hour increments?

I'm trying to create a daily to-do list spreadsheet that will break down my day into half hour increments...for example:

5:00-5:30
5:30-6:00
...so on

I'm not sure if it's possible to specify AM/PM, but that's not vital. Also, I'm hoping to find a way to allow each half hour increment to list more than one task- maybe 2 or 3..if that makes sense.

I'm probably making this overly complicated, so any suggestions are welcome- or if you know of a template I can download that may be similar to this this type of layout that would also be helpful.

Thank you!

In cells A1 and A2 enter the times.
A1: 05:00
A2: 05:30

Select both cells. Hover your mouse over A2 bottom right corner until the small cross appears, left click and drag down.

Suppose you start with this in A2:

8:00-8:30

(i.e. you enter the first range), then you can have this formula in A3:

=TEXT((LEFT(A2,FIND("-",A2)-1)&":00")*1+1/2/24,"h:mm-")&TEXT((LEFT(A2,FIND("-",A2)-1)&":00")*1+1/24,"h:mm")

which can then be copied down to give you the sequence you want.

If you need to duplicate one of the time ranges, eg. by having another 10:00-10:30 in cell A7, then you can just type that into the cell and the formulae below it will automatically adjust.

Hope this helps.

Pete

Originally Posted by Kevin UK

In cells A1 and A2 enter the times.
A1: 05:00
A2: 05:30

Select both cells. Hover your mouse over A2 bottom right corner until the small cross appears, left click and drag down.

I know this is an older thread, but this is exactly what I was looking for! Thank you very much.