Autofill - repeating values

[Guest]

I am trying to use autofill to poulate a large tiem
schedule. I would like a certain time to repeat, then
the next time to repeat and so on. For example:

9:15
9:15
9:20
9:20

Is this possible?

 

[Andy B]

Hi

Input 9:15 in row A2, and the same in row A3
In row 3 use =A3+0.003472 and in A4 type =A3
Select A3 and A4 and fill down.
Once done, you may wish to copy the column and Edit / Paste / Special /
Values to fix them in place

Andy.

 

[Guest]

Thanks! Perfect!

-----Original Message-----
Hi

Input 9:15 in row A2, and the same in row A3
In row 3 use =A3+0.003472 and in A4 type =A3
Select A3 and A4 and fill down.
Once done, you may wish to copy the column and Edit / Paste / Special /
Values to fix them in place

Andy.




.

 

[Andy B]

Thanks for saying 'Thanks'!!

Andy.

Thanks! Perfect!