Draging to copy cells

  • Thread starter Thread starter Krefty
  • Start date Start date
K

Krefty

I have some cells that are like this;

02/08/2004 07:01

Is there a way that I can drag the cell to continue
changing the time stamp without changing the date?

Thanks for any suggestions.

Krefty
 
Right-click on the fill handle (bottom left-hand corner of
cell), and while holding the mouse button, drag down.
Select "Copy Cells" in the pop-up window.

HTH
Jason
Atlanta, GA
 
Hi Krefty
one way:
in cell A1 enter
02/08/2004 07:01
in cell A2 enter
02/08/2004 07:02

select A1:A2 and drag down 8Excel will increment each cell by 1 minute)

Frank
 
Oops - misread the question. You could enter this in A2:

=A1+TIME(hr,min,sec)

and fill down. For example:

=A1+TIME(,5,)

will add 5 min increments and

=A1+TIME(,,30) will add 30 sec. increments.

HTH
Jason
Atlanta, GA
 
Back
Top