Draging to copy cells

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
 
J

Jason Morin

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
 
F

Frank Kabel

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
 
J

Jason Morin

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
 
Top