Putting consecutive time in cells

M

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.
 
R

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.
 
Top