Putting consecutive time in cells

[mrmnz]

Hello from New Zealand!

I want to make a diary using time in column A (see below) but autofilling
the cells rather than typing the times in. I've tried various things but get
variations on what I want:

6.00
6.30
7.00
7.30
etc
etc

Thanks so much.

 

[RagDyeR]

Use a colon, and then key in the first 2 times.

6:00
6:30

Select both cells and drag down to increment the series to the same interval
as the first 2 entries.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hello from New Zealand!

I want to make a diary using time in column A (see below) but autofilling
the cells rather than typing the times in. I've tried various things but
get
variations on what I want:

6.00
6.30
7.00
7.30
etc
etc

Thanks so much.

 

[mrmnz]

I knew it was going to be something real simple LOL!

Thanks a lot.

 

[RagDyer]

You're welcome, and appreciate the feed-back.