Autofill - repeating values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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




.
Click to expand...
 
Back
Top