Search Results

Okay, if I'm remembering correctly that was used because of something like the spreadsheet providing incorrect answers because it thought that the PM start times were after the AM end time.

So the IF() function works with three terms. The condition (think of it as a yes or no question), then statement (what do you want if the answer was yes), and the else statement (what do you want if the answer was no). HOUR() simply returns what was in the hour slot of the supplied timecode.

So we asked if the hour in the time code is above 12. If it is we subtract 1. If it wasn't we just wanted to use the time code as it is.

As explained earlier, the whole number part of a time code is the number of days, and the decimal part is the time. By subtracting one we keep the time the same, but move it to the previous day; thus avoiding the error.

As with most things in a relationship I think all is fair as long as you are open about what your expectations are. Just be aware that it could very well be a breaking point for some people if they can't, or don't want to, meet those expectations.

Personally I've been a virgin for 23 years and I don't foresee any issues keeping it that way indefinitely if my SO wanted. I would insist on allowance to masturbate in that case though. It wouldn't have to involve them in any way (I could even keep each instance secret), but I find that release quite important at times and wouldn't want to be lying about that. Though understandably some asexuals aren't okay with that option either as it involves your partner fantasizing about someone else, or imagining you in situations that you aren't okay with.

Cool. Just a brief rundown in case you want to modify the use later.

MROUND() rounds the first term to the nearest multiple of the second term. So =MROUND(14; 5) would result in 15. And it supports decimals and fractions and stuff so =MROUND(3.45; 0.2) would be 3.4.

Time codes are a number of days (It gets the date by starting at 1900's New Year). Then it gets hours and minutes from the decimal. So 0.5 would be noon, because that is half a day.

So combing those two you can round to time intervals. There are 1440 minutes in a day so rounding to the nearest 1/1440 is the same as rounding to the nearest minute. You could round to the nearest hour using 1/24 or round to the nearest 15 minutes with 15/1440 or 1/96.

This is the closest I'm finding. Though more details might help. Do you care if it is the flash? Do you care about live action vs animation? What details are you most concerned with? (because you won't get a perfect match) etc.

I don't have OpenOffice on my computer right now, but I think MROUND() will do the trick. I just don't know if the formula will take a time code. Try something like "=MROUND(A1; 0:01)" failing that "=MROUND(A1; 1/1440)" should work. Obviously swap A1 with the cell or value you actually want to round.

Ditto. It is all soft skills and work experience as a volunteer. I try to dress it up some, and at least I have a couple of IT certifications, but my experience thus far is that I'm lucky if I get a callback a month.

For me when it happens I can still paste in other tabs okay, and I haven't seen it happen elsewhere.

I use Chrome and the basic editor but I'll be happy to try it out when I next see it (though it is pretty rare)

The couple of times this has happened to me I fixed it by closing the browser and opening it back up. Would be nice to know why this happens though.

Best I can think is many phones need to be put into a USB mode. The phone should pop up a notification when it detects being plugged in and ask if you want to use it.

Excel uses comas, Open Office uses semicolons.

I'll have to back to you on time code rounding since that behaves oddly. If worse comes to worse I'm sure I can write one for you, though it may end up being a bit unwieldy.

I wasn't a fan of it in battle, though I can't really explain why. Just didn't feel satisfying I guess. I did like it as a form of transportation, though it was disappointing to find that the vast majority of platforming puzzles could be bypassed by jumping up a wall.

Yet another bump from someone that can't use it. Yaaaay.

The semicolon is a separation of terms in a function. Since SUM() adds all of its terms together it will basically mean the same as + in this case. But in any other function no.

My last post was actually typed from my bed. My brain hates me sometimes.

Sorry, I'm sleepy any don't know your spreadsheet well. I'm just saying that you can reference the cells where you've already summed things together instead of doing it again. Though while it is cleaner you risk doing stuff like I did (adding stuff twice, adding something that isn't relevant in both groups, failing to notice you didn't add something, etc.)

In the end as long as it makes sense to you, and it works, use whatever style you like.

I made a small edit above if you want to check that out

It doesn't matter if you put a lone cell in parentheses because that is mathematically valid. It just doesn't help because it will never do anything to that value.

My examples were from B22, as shown in your last screen shot. Well except for the 2+5+7=14 thing. That is just because it helps sometimes to see numbers in the functions rather than cell references.

Honestly, as long as you are sure it works, I don't see much problem with big ugly formulas. All you normally see is the result and some of the fun things you can do will just never look pretty (I'm looking at you IF() function)

Anywho. There are two big things you are missing that I can see.

First, in that last image you have a range without a function. You have "=SUM(B3:B6)+B10+(B13:B17)" but functions end when the parentheses next to it closes, so it has no idea what you are trying to do with (B13:B17). If you need to use it again you need to say that again, so you want "=SUM(B3:B6)+B10+SUM(B13:B17)"

Second, you can have more terms than you would ever want to use in a SUM() function. To separate them you just use a semicolon so "=SUM(2;5;7)" would display 14. Using this we can further condense the formula used above by dropping those plus signs and only calling the function once. Do that and you have, "=SUM(B3:B6; B10; B13:B17)"


EDIT: On a second look you can also make your life easier because the ranges you are summing are already done on the sheet. So you could use "=SUM(B7; B11; B18)"

I don't have access to a Win 8 computer, but on my Win 7 you can find scan scheduling in Tools > Options > Automatic Scanning.

I know them feels. I've restarted Child of Light three times now and still haven't finished it, it is a good game and isn't that long for crying out loud.

Usually when I get in moods like this I load up a game that practically plays itself like FF12 or something in the Tales Of series.