| Tech Board|| re: Need some Excel help - Guess on 1/15/15 at 3:37 pm|
I ended up using =IF(ISBLANK(A2),"",A2+Timel(0,29,0)) and dragged just dragged it down. ...
| Tech Board|| re: Need some Excel help - Guess on 1/14/15 at 2:58 am|
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 C...
| Tech Board|| re: Need some Excel help - Guess on 1/14/15 at 12:23 am|
[quote]You'll need a macro with auto fill script or copy a "if"statement for the entire column.[/quote]
Can you give an example of what that would look like?...
| Tech Board|| re: Need some Excel help - Guess on 1/14/15 at 12:18 am|
Unless I'm missing something, that only gives the correct answer in B1. Any additions to column A give nothing.
I tried B2:B1000000 as the range in the top left box and used =A2:A1000000+Time(0,29,0), but that still only gives the correct answer in B2.(note I'm...
| Tech Board|| Need some Excel help - Guess 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.
[u][b]Start time[/b]____________________________[b]End Time[/b]
| SEC Rant|| re: Once the big 12 finally implodes - Guess on 12/30/14 at 9:49 pm|
If the money gap continues to grow all of them will listen to the B1G or SEC under the right situation. As much snobbery as they Portray, I think the last thing NC wants is NC state in the SEC. Va might be a different story with Va Tech though, they may not care....
| SEC Rant|| re: Once the big 12 finally implodes - Guess on 12/30/14 at 5:52 pm|
The SEC shouldn't and won't go after any Big 12 teams, but if it blows up, the dynamics of things change. That means the ACC has officially won it's spot as the 4th big boy making it even less likely to get anyone out of there.
Because of GOR it's probably going to take the conference ...
| O-T Lounge|| re: Quality Brands That Are Now Gone - Guess on 12/25/14 at 1:43 am|
| O-T Lounge|| re: Does ayone have any updated info on the 21 year old with the underage girl in BR - Guess on 12/25/14 at 1:26 am|
[quote]The statute protects a class of persons. You want the protected class to be an accessory to the crime the law promises to protect them from?[/quote]
Then why would it be possible to charge that same girl with distributing child pornography if she had sent someone nudes of herself. :dunno:...
| O-T Lounge|| re: Have the SJWs weighed in on the Joe Boxer pregnant women TV ad yet? - Guess on 12/23/14 at 2:21 am|
Not sure what SJW is, but if you're talking about the Kmart comercial, I :lol: every time I see it....
| O-T Lounge|| re: Group racks up $350 restaurant bill, proceeds to assault waitress/kitchen staff - Guess on 12/18/14 at 10:56 am|
[quote]its when a black person would tip like 200% to a shitty server, because they want them to know they are not ni....[/quote]
I waited tables for a while and I get the stereotype. I even have friends that I don't like to go out to eat with because they can't seem to understand that servers ba...
| O-T Lounge|| re: Gamma ray bursts could be why no one is talking to us from space - Guess on 12/11/14 at 11:55 pm|
[quote]Space is crazy man. It's mindblowing to think how big it is out there and it's over 5 billion years old! [/quote]
The universe is supposed to be around 13.8 billion years old and the solar system is supposed to be around 4.6 billion years old, and to me that isn't even that hard to conce...
| O-T Lounge|| re: Which is correct? One space or two spaces to start a new sentence? - Guess on 12/11/14 at 9:30 pm|
I'm in my mid 30's and 1 space looks right, but feels wrong because of how I was raised. :lol:...
| O-T Lounge|| re: Do Land Line Phone Companies Still Charge for Long Distance? - Guess on 12/6/14 at 9:08 pm|
They have [link=(https://itunes.apple.com/us/app/talkatone-free-text-messaging/id397648381?mt=8)]talkatone[/link] for IOS, but I didn't see GrooveIP. ...
| O-T Lounge|| re: Do Land Line Phone Companies Still Charge for Long Distance? - Guess on 12/6/14 at 8:47 pm|
Not complicated at all. If you have Android, I know of 2 options.
1)Talkatone has free incoming calls and free incoming and outgoing text messaging. Outgoing calls have a really cheap per minute rate, but you would only be using it to receive calls anyway.
2) GrooveIP has free incoming and out...
| O-T Lounge|| re: Do Land Line Phone Companies Still Charge for Long Distance? - Guess on 12/6/14 at 8:24 pm|
[quote]Think I have my answer. I need to get a new local cell service provider.[/quote]
Did you even see my response? If you really want to keep your current number, then you can just attach a separate local VOIP number to your phone and it's free to do. If you just have decided that you want to ...
| More Sports Board|| re: Anyone having no sound on Fox for Ohio st/Wisc - Guess on 12/6/14 at 7:09 pm|
I'll stream it live on ustream or something. :nana:...
| O-T Lounge|| re: Do Land Line Phone Companies Still Charge for Long Distance? - Guess on 12/6/14 at 7:05 pm|
No one really uses landlines anyway, but you could always just keep your current number and download something like GrooveIP and attach a seperate local VOIP number to your cell phone to give out for things like your job....
| More Sports Board|| re: Anyone having no sound on Fox for Ohio st/Wisc - Guess on 12/6/14 at 6:53 pm|
Audio just came back as I was about to go look for some rabbit ears. :lol:...
| More Sports Board|| re: Anyone having no sound on Fox for Ohio st/Wisc - Guess on 12/6/14 at 6:39 pm|
I have no sound on Cox in NOLA....