Search | TigerDroppings.com



Posts By Guess
ForumMessage
Tech Board
re: Need some Excel help - Guess
I ended up using =IF(ISBLANK(A2),"",A2+Timel(0,29,0)) and dragged just dragged it down. ...


Jump to Post in Topic - View Entire Topic - Replies (0)
Tech Board
re: Need some Excel help - 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 C...


Jump to Post in Topic - View Entire Topic - Replies (2)
Tech Board
re: Need some Excel help - Guess
[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?...


Jump to Post in Topic - View Entire Topic - Replies (1)
Tech Board
re: Need some Excel help - Guess
[quote]=A1+TIME(0,29,0) [/quote] 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...


Jump to Post in Topic - View Entire Topic - Replies (0)
Tech Board
Need some Excel help - Guess
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: [u][b]Start time[/b]____________________________[b]End Time[/b] __6:00 pm______________...


Jump to Post in Topic - View Entire Topic - Replies (2)
SEC Rant
re: Once the big 12 finally implodes - Guess
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....


Jump to Post in Topic - View Entire Topic - Replies (0)
SEC Rant
re: Once the big 12 finally implodes - Guess
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 ...


Jump to Post in Topic - View Entire Topic - Replies (0)
O-T Lounge
re: Quality Brands That Are Now Gone - Guess
[img]data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxQTEhUUExQWFhUXFxcUGBcXGBQXFxQaGBUXFhcXFRQYHCggGBolHBQVITEhJSkrLi4uFx8zODMsNygtLisBCgoKDg0OGhAQGiwkHyQsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCssLCwsNzcsK//AABEIASQAoAMBIgACEQEDEQH/xAAcAAABBQEBAQAAAAAAAAAAAAADAAIEBQYBBwj/...


Jump to Post in Topic - View Entire Topic - Replies (1)
O-T Lounge
re: Does ayone have any updated info on the 21 year old with the underage girl in BR - Guess
[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:...


Jump to Post in Topic - View Entire Topic - Replies (1)
O-T Lounge
re: Have the SJWs weighed in on the Joe Boxer pregnant women TV ad yet? - Guess
Not sure what SJW is, but if you're talking about the Kmart comercial, I :lol: every time I see it....


Jump to Post in Topic - View Entire Topic - Replies (0)
O-T Lounge
re: Group racks up $350 restaurant bill, proceeds to assault waitress/kitchen staff - Guess
[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...


Jump to Post in Topic - View Entire Topic - Replies (0)
O-T Lounge
re: Gamma ray bursts could be why no one is talking to us from space - Guess
[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...


Jump to Post in Topic - View Entire Topic - Replies (1)
O-T Lounge
re: Which is correct? One space or two spaces to start a new sentence? - Guess
I'm in my mid 30's and 1 space looks right, but feels wrong because of how I was raised. :lol:...


Jump to Post in Topic - View Entire Topic - Replies (0)
O-T Lounge
re: Do Land Line Phone Companies Still Charge for Long Distance? - Guess
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. ...


Jump to Post in Topic - View Entire Topic - Replies (0)
O-T Lounge
re: Do Land Line Phone Companies Still Charge for Long Distance? - Guess
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...


Jump to Post in Topic - View Entire Topic - Replies (1)
O-T Lounge
re: Do Land Line Phone Companies Still Charge for Long Distance? - Guess
[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 ...


Jump to Post in Topic - View Entire Topic - Replies (1)
More Sports Board
re: Anyone having no sound on Fox for Ohio st/Wisc - Guess
I'll stream it live on ustream or something. :nana:...


Jump to Post in Topic - View Entire Topic - Replies (0)
O-T Lounge
re: Do Land Line Phone Companies Still Charge for Long Distance? - Guess
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....


Jump to Post in Topic - View Entire Topic - Replies (1)
More Sports Board
re: Anyone having no sound on Fox for Ohio st/Wisc - Guess
Audio just came back as I was about to go look for some rabbit ears. :lol:...


Jump to Post in Topic - View Entire Topic - Replies (1)
More Sports Board
re: Anyone having no sound on Fox for Ohio st/Wisc - Guess
I have no sound on Cox in NOLA....


Jump to Post in Topic - View Entire Topic - Replies (0)

Posts By Guess