help

Copper Contributor

I have a time 7:30 in a cell.  I would like to add 9 to each of the following cells(35 times)

6 Replies

@joedi02 

Add 9 hours or 9 minutes or 9 seconds or what?

@Sergei Baklan 

 

9 minute i.e 7:30, 7:39 etc

@joedi02 

You may enter into the cell below formula as here and drag cell down

image.png

alternatively in A1: =SEQUENCE(16,,TIME(7,30,0),TIME(0,9,0))
did not work. all I got in colunm A is NAME
What version of Excel do you have? I suspect you don't have MS 365 and hence don't have the function SEQUENCE. An easy way to test is to start typing the equation =SE... and you should see a list of potential functions and if when you get to =SEQ that list is blank/goes away that means your version of Excel doesn't have that function/ability. BTW in that case just use Sergei's solution as that should work just fine.