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.

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!
================================================== ===

"mrmnz" wrote in message
...
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.

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

Thanks a lot.



"RagDyeR" wrote:

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!
================================================== ===

"mrmnz" wrote in message
...
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.

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mrmnz" wrote in message
...
I knew it was going to be something real simple LOL!

Thanks a lot.



"RagDyeR" wrote:

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!
================================================== ===

"mrmnz" wrote in message
...
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.