help

%3CLINGO-SUB%20id%3D%22lingo-sub-2594311%22%20slang%3D%22en-US%22%3Ehelp%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594311%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20time%207%3A30%20in%20a%20cell.%26nbsp%3B%20I%20would%20like%20to%20add%209%20to%20each%20of%20the%20following%20cells(35%20times)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2594311%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594578%22%20slang%3D%22en-US%22%3ERe%3A%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594578%22%20slang%3D%22en-US%22%3EWhat%20version%20of%20Excel%20do%20you%20have%3F%20I%20suspect%20you%20don't%20have%20MS%20365%20and%20hence%20don't%20have%20the%20function%20SEQUENCE.%20An%20easy%20way%20to%20test%20is%20to%20start%20typing%20the%20equation%20%3DSE...%20and%20you%20should%20see%20a%20list%20of%20potential%20functions%20and%20if%20when%20you%20get%20to%20%3DSEQ%20that%20list%20is%20blank%2Fgoes%20away%20that%20means%20your%20version%20of%20Excel%20doesn't%20have%20that%20function%2Fability.%20BTW%20in%20that%20case%20just%20use%20Sergei's%20solution%20as%20that%20should%20work%20just%20fine.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594543%22%20slang%3D%22en-US%22%3ERe%3A%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594543%22%20slang%3D%22en-US%22%3Edid%20not%20work.%20all%20I%20got%20in%20colunm%20A%20is%20NAME%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594519%22%20slang%3D%22en-US%22%3ERe%3A%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594519%22%20slang%3D%22en-US%22%3Ealternatively%20in%20A1%3A%20%3DSEQUENCE(16%2C%2CTIME(7%2C30%2C0)%2CTIME(0%2C9%2C0))%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594495%22%20slang%3D%22en-US%22%3ERe%3A%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594495%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1114938%22%20target%3D%22_blank%22%3E%40joedi02%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20enter%20into%20the%20cell%20below%20formula%20as%20here%20and%20drag%20cell%20down%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20260px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F299103iA224AF3385A51068%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594471%22%20slang%3D%22en-US%22%3ERe%3A%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594471%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E9%20minute%20i.e%207%3A30%2C%207%3A39%20etc%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594463%22%20slang%3D%22en-US%22%3ERe%3A%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594463%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1114938%22%20target%3D%22_blank%22%3E%40joedi02%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAdd%209%20hours%20or%209%20minutes%20or%209%20seconds%20or%20what%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.