- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Need some Excel help
Posted on 1/13/15 at 9:20 pm
Posted on 1/13/15 at 9:20 pm
I have a form that automatically updates a Google spreadsheet with a time value. I need another column to simply add 29 minutes to that time value in the corresponding row of the other column.
For example:
Start time____________________________End Time
__6:00 pm_______________________(need 6:29 pm to show here)
There is no limit, I just need the second time to show up automatically after the initial time is added to the calendar. I do know that to add time you use +Time(Hr,Min,Sec)
An easier example without time is simply
Number____________________________Number and 3
___2__________________________(I would need 5 to show up here)
I can do it for each row manually, but I need it to be done automatically soon as a new row is added from the form.
For example:
Start time____________________________End Time
__6:00 pm_______________________(need 6:29 pm to show here)
There is no limit, I just need the second time to show up automatically after the initial time is added to the calendar. I do know that to add time you use +Time(Hr,Min,Sec)
An easier example without time is simply
Number____________________________Number and 3
___2__________________________(I would need 5 to show up here)
I can do it for each row manually, but I need it to be done automatically soon as a new row is added from the form.
This post was edited on 1/13/15 at 9:24 pm
Posted on 1/13/15 at 9:38 pm to Guess
You'll need a macro with auto fill script or copy a "if"statement for the entire column.
Posted on 1/15/15 at 12:17 pm to Guess
You have to create a Macro.
If your Developer Tab is not visible, add it by customizing the toolbar ribbon under "File:Options". Once you have the developer ribbon displayed, then simply click on Developer->Insert->Form Control->Button
It will popup with the list of Macros to assign to the button. Select the macro you want. The one I have above basically copies the active row and inserts it directly below. So basically, each new row is an exact duplicate of whatever row is currently active.
You can dress this up by specifying the active range to copy from -- that way instead of relying on the user to have the "right row" highlighted, it always copies the same row and inserts it into the same place in the sheet.
quote:
Sub macroNewRow()
ActiveCell.EntireRow.Select
Selection.Copy
Selection.Insert Shift:=xlDown
End Sub
If your Developer Tab is not visible, add it by customizing the toolbar ribbon under "File:Options". Once you have the developer ribbon displayed, then simply click on Developer->Insert->Form Control->Button
It will popup with the list of Macros to assign to the button. Select the macro you want. The one I have above basically copies the active row and inserts it directly below. So basically, each new row is an exact duplicate of whatever row is currently active.
You can dress this up by specifying the active range to copy from -- that way instead of relying on the user to have the "right row" highlighted, it always copies the same row and inserts it into the same place in the sheet.
Popular
Back to top
![logo](https://images.tigerdroppings.com/images/layout/TDIcon.jpg)