Hi again, I have been using this formula to add a certain amount of time to a cell: =C2 + TIME(0,7,0) - in this case, 7 minutes. However, I want to add the same amount of time to all cells in a particular column. Thus far I have been C+P-ing this formula into a cell, then overtyping 2 with 3, 4 etc until I get all the cells filled in.
Is there a quicker way to populate all cells in a column with this formula so that it steps up and I don't have to manually type in each one?
I'm new to formulas and am having a great time with this project, but I really don't want to spend hours on it ...
Is there a quicker way to populate all cells in a column with this formula so that it steps up and I don't have to manually type in each one?
I'm new to formulas and am having a great time with this project, but I really don't want to spend hours on it ...