- 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 3:26 pm to Guess
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)