Number sequence

B

Brento

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
 
G

Gord Dibben

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 Format>Cells>Number>Time

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

Drag/copy across row 1.


Gord Dibben MS Excel MVP
 
E

excelent

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



"Brento" skrev:
 
Top