- 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
re: Need some Excel help
Posted on 1/14/15 at 2:58 am to Guess
Posted on 1/14/15 at 2:58 am to Guess
Ok, I used =ARRAYFORMULA(A2:A+Time(0,29,0)) in B2 and it works pretty well. Anytime a time or date and time is added to column A, I automatically get the correct result in column B. Now the problem I have is that column B is filled with results based off of 0 even if nothing is in column A. I need Column B to stay empty unless Column A has a date or date and time.
ETA: I asked for Excel help, but I'm realizing Google Spreadsheets is a little different from both Open Office and Excel.
ETA: I asked for Excel help, but I'm realizing Google Spreadsheets is a little different from both Open Office and Excel.
This post was edited on 1/14/15 at 3:52 am
Posted on 1/14/15 at 8:08 am to Guess
=IF(A3="","",A3+TIME(0,29,0))
works in excel for me. You have to drag it down indefinitely through how far you expect the table to extend.
works in excel for me. You have to drag it down indefinitely through how far you expect the table to extend.
Posted on 1/14/15 at 3:26 pm to Guess
quote:
Posted by Guess
Ok, I used =ARRAYFORMULA(A2:A+Time(0,29,0)) in B2 and it works pretty well. Anytime a time or date and time is added to column A, I automatically get the correct result in column B. Now the problem I have is that column B is filled with results based off of 0 even if nothing is in column A. I need Column B to stay empty unless Column A has a date or date and time.
ETA: I asked for Excel help, but I'm realizing Google Spreadsheets is a little different from both Open Office and Excel.
This is why I suggested the "if" statement. Just plug in if and the value if 0=" ""
Popular
Back to top
![logo](https://images.tigerdroppings.com/images/layout/TDIcon.jpg)