automatically changing time values

%3CLINGO-SUB%20id%3D%22lingo-sub-2188386%22%20slang%3D%22en-US%22%3Eautomatically%20changing%20time%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2188386%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20spreadsheet%20that%20changes%20time%20from%20an%20input%20column%26nbsp%3Bby%20a%20specific%20amount%20with%20the%20result%20in%20another%20column%20(see%20screen%20capture).%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Capture.JPG%22%20style%3D%22width%3A%20465px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F261230i3A3BE68EBE876421%2Fimage-dimensions%2F465x223%3Fv%3D1.0%22%20width%3D%22465%22%20height%3D%22223%22%20role%3D%22button%22%20title%3D%22Capture.JPG%22%20alt%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20(Time%20entered%20in%20Column%20E%20is%20adjusted%20by%2045%20minutes%20and%20displayed%20in%20column%20F)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BUsing%20the%26nbsp%3BTIME%20function%20doesn't%20work%20but%20I%20found%20that%20FILL%20SERIES%20will%20work%20however%20I%20have%20to%20do%20each%20column%20manually.%26nbsp%3B%20Is%20there%20a%20way%20to%20format%20the%20column%20to%20do%20this%20automatically%20as%20each%20cell%20is%20filled%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2188386%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2188834%22%20slang%3D%22en-US%22%3ERe%3A%20automatically%20changing%20time%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2188834%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F988396%22%20target%3D%22_blank%22%3E%40dls5u%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20enter%20into%20F2%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DE2%2B45%2F60%2F24%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eafter%20that%20double%20click%20on%20the%20dot%20at%20right%20bottom%20of%20the%20frame%20around%20the%20cell%3B%20or%20drag%20it%20down%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I am trying to create a spreadsheet that changes time from an input column by a specific amount with the result in another column (see screen capture).Capture.JPG

                  (Time entered in Column E is adjusted by 45 minutes and displayed in column F)

 

 Using the TIME function doesn't work but I found that FILL SERIES will work however I have to do each column manually.  Is there a way to format the column to do this automatically as each cell is filled?

7 Replies

@dls5u 

You may enter into F2

=E2+45/60/24

after that double click on the dot at right bottom of the frame around the cell; or drag it down

@dls5u

Enter the following formula in F2:

 

=IF(E2="", "", E2+TIME(0,45,0))

 

Fill down from F2 as far as you want.

Thanks. That was what I needed.
I tried this and was told that I had too many arguments. It does seem that this is a more elegant approach but I'll have to toy with it to get it working. Thanks

@dls5u 

It works for me:

 

S0192.png

 

If you use comma as decimal separator, the formula would be

 

=IF(E2=""; ""; E2+TIME(0;45;0))

Got it! I modified your formula to: IF(E2="","",E2+45/60/24) and this gave me what I was going for. Thanks
I'm not sure why it said too many arguments. It looked like it should work to me.