Number sequence
 

HI

I am trying to highlight a column and move it across right there are
different times in the columns all at 15 mintue intervals.

What I am trying to do is move it accross 1 column and rather than add
on 1 hour to the time I need it to add on 15minutes instead?


I am open to any takers?

Thanks
Brento


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=561783

Number sequence
 

In A1 enter a static time by hitting CTRL + SHIFT + ;

Or enter =NOW() in A1 to have an updating time.

Format row 1 as Time fro FormatCellsNumberTime

In B1 enter =A1 + TIME(0,15,0)

Drag/copy across row 1.


Gord Dibben MS Excel MVP

On Sat, 15 Jul 2006 18:11:35 -0400, Brento
wrote:


HI

I am trying to highlight a column and move it across right there are
different times in the columns all at 15 mintue intervals.

What I am trying to do is move it accross 1 column and rather than add
on 1 hour to the time I need it to add on 15minutes instead?


I am open to any takers?

Thanks
Brento

Number sequence
 

put in B1 or cell right to ur timevalue and copy right
=A1+TIME(0;15;0)
custumformat as oo:mm



"Brento" skrev:


HI

I am trying to highlight a column and move it across right there are
different times in the columns all at 15 mintue intervals.

What I am trying to do is move it accross 1 column and rather than add
on 1 hour to the time I need it to add on 15minutes instead?


I am open to any takers?

Thanks
Brento


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=561783

Number sequence
 

ups
=A1+TIME(0,15,0)




"excelent" skrev:

put in B1 or cell right to ur timevalue and copy right
=A1+TIME(0;15;0)
custumformat as oo:mm



"Brento" skrev:


HI

I am trying to highlight a column and move it across right there are
different times in the columns all at 15 mintue intervals.

What I am trying to do is move it accross 1 column and rather than add
on 1 hour to the time I need it to add on 15minutes instead?


I am open to any takers?

Thanks
Brento


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=561783