|
Posted to microsoft.public.excel.misc
|
|
|
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
|