|
the posted:I added all of the names and track lengths to a Google Spreadsheet, so it looks like this: You can highlight your column with times in it, select Format->Number->Duration. This might case your 2:30 value to be reprinted as 2:30:00; an easy fix is to set the C column to contain =B1/60, and then drag this all the way down. Then, copy C, and Paste Special->Paste Values Only from C into B. Once google is aware that your values are durations instead of times, the addition should work properly.
|
#
?
May 2, 2014 19:40
|
|
|
|
| # ? May 22, 2024 11:14 |
|
|
I figured out what was going on. It was interpreting 2:30 as HH:MM, so it was giving me an answer of .208333 which is 5 hours out of a 24 hour day, which is correct. So the sum command does work, I just have the times formatted incorrectly.
|
|
#
?
May 2, 2014 19:41
|
|
|
the posted:I added all of the names and track lengths to a Google Spreadsheet, so it looks like this: When I put 2:30 into a cell, the spreadsheet interprets that to mean 2 hours 30 seconds.  When I add two cells containing 2:30 together, I get 5:00  Anyway, what's happening with you is that the cell is displaying the numerical value of 5 hours (5 hours = 24 hours * 0.2083).  If you click Format>Number>Time you'll get the cell to display 5:00 (just be aware that the spreadsheet interprets this as 5 hours 0 minutes instead of 5 minutes 0 seconds).
|
|
#
?
May 2, 2014 19:43
|
|
man
|
OctoberBlues posted:Around 2006/2007 I put up some pictures on a site that was like flickr and I would love to find them again. I am pretty sure I know what my username and password would have been, but I can't remember the site. I thought maybe it was photobucket, but it doesn't look like it. Any idea what the most popular flickr type sites were 7-8 years ago? picasa?
|
|
#
?
May 2, 2014 19:46
|
|
|
Li-King Wang posted:Anyone know who this guy is? He's been hanging around my work for a few days now and nobody knows who he is or where he came from. Nope, definitely not. Sorry. appleskates fucked around with this message at 22:03 on May 2, 2014 |
|
#
?
May 2, 2014 22:01
|
|
|
Is the newest fad in scamming and/or selling stolen poo poo driving up and trying to sell stuff to random people on the street with the story of "I was going to deliver <expensive thing> but <thing> happened and <reason I can't be rid of it> so do you want to buy it?" In the past year I've been annoyed by these people several times.
|
|
#
?
May 3, 2014 03:27
|
|
|
Leal posted:Is the newest fad in scamming and/or selling stolen poo poo driving up and trying to sell stuff to random people on the street with the story of "I was going to deliver <expensive thing> but <thing> happened and <reason I can't be rid of it> so do you want to buy it?" In the past year I've been annoyed by these people several times. No, that's a very old trick, though usually it's just lovely stuff tricked out to make it look like it was stolen, so people think they're getting a deal.
|
|
#
?
May 3, 2014 03:29
|
|
|
With the Amazon cloud player, can I download the music to a PC and then transfer it over to a linux machine? I need to get it on the linux machine.
|
|
#
?
May 3, 2014 04:09
|
|
|
What's the harm in setting a refrigerator horizontal for a move? There's no exposed coils and it's just a smallish apartment size fridge. I haven't moved one in quite some time but seem to recall everyone would freak out if you tipped it over and laid it flat, like all the cool stuff would leak out or some poo poo
|
|
#
?
May 3, 2014 05:31
|
|
|
Ruby got Railed posted:What's the harm in setting a refrigerator horizontal for a move? There's no exposed coils and it's just a smallish apartment size fridge. I haven't moved one in quite some time but seem to recall everyone would freak out if you tipped it over and laid it flat, like all the cool stuff would leak out or some poo poo If possible transport it at an angle, raising the top side as much as you can. http://www.geappliances.com/search/fast/infobase/10000318.htm randyest fucked around with this message at 05:51 on May 3, 2014 |
|
#
?
May 3, 2014 05:48
|
|
|
I somehow stumbled upon these extra option screens for YouTube for HTML5 and this interface option called Feather, and I'm not sure how I found them or how you're meant to get to them normally. I found the URLs for them just now by Googling them. Are there any others like that and is there a place you can access them from normally? I can't see them anywhere in the YouTube settings.
|
|
#
?
May 3, 2014 11:05
|
|
|
the posted:With the Amazon cloud player, can I download the music to a PC and then transfer it over to a linux machine? I need to get it on the linux machine. Yes. The file itself is just an .mp3, so once you have the physical file, you can transfer it to whatever computer you need to.
|
|
#
?
May 3, 2014 13:38
|
|
|
Is there a way to shut down Windows 8 without installing updates? I tried Googling and all I find are methods for Windows 7 that don't work in 8. Sometimes I just want to restart my computer without waiting five minutes.
|
|
#
?
May 3, 2014 14:11
|
|
|
Is there a name -- or one of those fancy German words -- for the phenomenon where you are given free, unfettered creative ability and you draw a blank as to what to do? The best I can find is "Blank Page Syndrome" but for my purposes, something where the first Google result is urban dictionary isn't ideal.
|
|
#
?
May 3, 2014 15:58
|
|
|
Nighthand posted:Is there a name -- or one of those fancy German words -- for the phenomenon where you are given free, unfettered creative ability and you draw a blank as to what to do? The best I can find is "Blank Page Syndrome" but for my purposes, something where the first Google result is urban dictionary isn't ideal. http://en.wikipedia.org/wiki/The_Paradox_of_Choice is close.
|
|
#
?
May 3, 2014 16:03
|
|
|
That'll work unless I stumble on something better, thanks.
|
|
#
?
May 3, 2014 16:37
|
|
|
There's also http://en.wikipedia.org/wiki/Analysis_paralysis
|
|
#
?
May 3, 2014 16:51
|
|
|
Tiggum posted:Is there a way to shut down Windows 8 without installing updates? I tried Googling and all I find are methods for Windows 7 that don't work in 8. Sometimes I just want to restart my computer without waiting five minutes. 5 minute restart? Get a new computer man.
|
|
#
?
May 3, 2014 17:37
|
|
|
the posted:5 minute restart? Get a new computer man. Hyperbole. I just mean that I don't want to waste time installing updates when I just want my computer to restart.
|
|
#
?
May 3, 2014 18:12
|
|
|
My department is hiring two people for a three-person, entry level team. The two positions are open because one person left due to bullying and the other was fired for bullying the person who left. The existing person is apparently going to be part of the 2nd round interviews. This seems like a very big red flag to me, as I feel like it immediately creates a dynamic in which the new hires will immediately look to the existing person as a superior based on the fact that they were involved in the interviews. Am I wrong?
|
|
#
?
May 3, 2014 19:04
|
|
|
No, but I would say that they would look to the person for leadership naturally because that person will know how to do the job and all the ins and outs. Seniority and experience usually means leader ship roles.
|
|
#
?
May 3, 2014 19:10
|
|
|
the posted:No, but I would say that they would look to the person for leadership naturally because that person will know how to do the job and all the ins and outs. Seniority and experience usually means leader ship roles. Oh absolutely, the existing person will be a great resource for how to perform daily functions. I just feel like it's a conflict of interest wherein the existing person will be looking for people they get along with and/or can manipulate, rather than the most qualified person for the job. Obviously team chemistry is important but I feel like that should be a manager decision.
|
|
#
?
May 3, 2014 19:21
|
|
|
GobiasIndustries posted:My department is hiring two people for a three-person, entry level team. The two positions are open because one person left due to bullying and the other was fired for bullying the person who left. The existing person is apparently going to be part of the 2nd round interviews. This seems like a very big red flag to me, as I feel like it immediately creates a dynamic in which the new hires will immediately look to the existing person as a superior based on the fact that they were involved in the interviews. Am I wrong? At my work, anyone on the team might help out on the interviewing process. Hell, I've interviewed applicants for the position of my own boss. It's never been a problem.
|
|
#
?
May 3, 2014 19:28
|
|
|
Do people who talk with a lisp think with a lisp? Like if they're thinking about a speech or something they're going to give, as they're planning it out do they hear a lisp in their head? Would the answer vary depending on the cause of the lisp or is it one of those things where it's like hearing a recording of yourself and you say "I don't sound like that!"
|
|
#
?
May 3, 2014 19:46
|
|
|
Crankit posted:Do people who talk with a lisp think with a lisp? Like if they're thinking about a speech or something they're going to give, as they're planning it out do they hear a lisp in their head? Would the answer vary depending on the cause of the lisp or is it one of those things where it's like hearing a recording of yourself and you say "I don't sound like that!" I'm guessing yes unless their lisp is due to not being able to hear the difference between the two sounds.
|
|
#
?
May 3, 2014 20:04
|
|
|
GobiasIndustries posted:My department is hiring two people for a three-person, entry level team. The two positions are open because one person left due to bullying and the other was fired for bullying the person who left. The existing person is apparently going to be part of the 2nd round interviews. This seems like a very big red flag to me, as I feel like it immediately creates a dynamic in which the new hires will immediately look to the existing person as a superior based on the fact that they were involved in the interviews. Am I wrong? Interviewing potential coworkers is incredibly common in software - I've "hired" two peers, and two people who were hired for a more senior position. I have a much better idea of what skills are necessary for the position than, say, HR would, because I've been doing it for a few years. And, I mean, so what if they treat him as a superior? They probably will, especially at first. As long as you don't think that the existing person is utterly unqualified to act as an informal leader, I don't see a problem.
|
|
#
?
May 3, 2014 20:10
|
|
|
Crankit posted:Do people who talk with a lisp think with a lisp? Like if they're thinking about a speech or something they're going to give, as they're planning it out do they hear a lisp in their head? Would the answer vary depending on the cause of the lisp or is it one of those things where it's like hearing a recording of yourself and you say "I don't sound like that!" Former severe lisper, currently intermittent / mild lisp. No, but I'm hyper aware of problematic words that will come up in the flow of my speech. gently caress "sixty-six". Sk- words are tough. -ks is tough too, so "asks" sucks (as does "sucks") Curiously, I didn't even know I had a lisp until I was 9 or so, didn't even hear it, so certainly didn't think in a lisp. Having a lisp does give you a (rather lame) superpower - you can always tell a former lisper who fixed it via speech therapy. The production of the s sound is different. Lisping is often caused by structural issues with the jaw, tongue, or soft palate and so the standard way of making the sound simply doesn't work, and the way you learn to make the sound is subtly different. I doubt non-lispers would be able to tell but it's instantly obvious to me. I'd wager quite a bit that, for example, Peter Dinklage and Brian Williams of NBC News were lispers. Christian Bale too, but his is more obvious and not entirely fixed. E: if I do lisp in a sentence now, I definitely hear it, but I "know" it even more than I hear it, if that makes sense. It feels different. But I don't and never have thought with a lisp. regulargonzalez fucked around with this message at 20:22 on May 3, 2014 |
|
#
?
May 3, 2014 20:17
|
|
|
GobiasIndustries posted:My department is hiring two people for a three-person, entry level team. The two positions are open because one person left due to bullying and the other was fired for bullying the person who left. The existing person is apparently going to be part of the 2nd round interviews. This seems like a very big red flag to me, as I feel like it immediately creates a dynamic in which the new hires will immediately look to the existing person as a superior based on the fact that they were involved in the interviews. Am I wrong? They do this where I work and it isn't an issue. It's good for the potential employees to be able to ask questions to a current person in that spot.
|
|
#
?
May 3, 2014 21:17
|
|
|
Crankit posted:Do people who talk with a lisp think with a lisp? Like if they're thinking about a speech or something they're going to give, as they're planning it out do they hear a lisp in their head? Would the answer vary depending on the cause of the lisp or is it one of those things where it's like hearing a recording of yourself and you say "I don't sound like that!" I had a lisp for several years due to some dental gear and I never heard it in my head. I got used to how the lisp "felt" when I spoke, but I was still aware is was abnormal when I listened to myself.
|
|
#
?
May 4, 2014 02:06
|
|
|
What's the best tool for sharing a slideshow? My parents want to show us photos from their vacation and I thought it would be easy to find a photo live streaming tool so they could click through photos while talking about them on a phone call. Is there anything that will do this? I assume they could just skype and use a tool to show their desktop instead of webcam but I was hoping for fairly high quality as well, so something they upload to and then control from their end would be best.
|
|
#
?
May 4, 2014 03:36
|
|
|
tuyop posted:What's the best tool for sharing a slideshow? My parents want to show us photos from their vacation and I thought it would be easy to find a photo live streaming tool so they could click through photos while talking about them on a phone call. It requires a subscription but is free for 30 days. Webex might also work but it would be even more expensive. Maybe a shared photostream?
|
|
#
?
May 4, 2014 04:44
|
|
|
How is contemplative practice (ie meditation, yoga, prayer) different to ordinary self-reflection or study?
|
|
#
?
May 4, 2014 05:22
|
|
|
Is there a category of eating disorder* in which your body has trouble identifying when hunger has been sated but your habits are otherwise normal? * that is, assuming it can even be considered an eating disorder if it doesn't involve the impulsive or compulsive consumption/avoidance of food.
|
|
#
?
May 4, 2014 08:41
|
|
|
Can someone tell me how people can find old threads in the archive? Is it simply a matter of knowing vaguely when the thread was posted and looking around, or is there some obvious search functionality I'm unaware of? I'd love to know how this is accomplished. I generally rely on others to pull old threads and link them in the current forums, and if there's a big thread from the past I'm interested in, I'll bookmark it so I can read it at leisure.
|
|
#
?
May 4, 2014 14:51
|
|
|
GobiasIndustries posted:Oh absolutely, the existing person will be a great resource for how to perform daily functions. I just feel like it's a conflict of interest wherein the existing person will be looking for people they get along with and/or can manipulate, rather than the most qualified person for the job. Obviously team chemistry is important but I feel like that should be a manager decision. Why? Is the manager some kind of hyper intuitive matchmaker? You'd think a team that just lost two people due to "bullying" would appreciate personality fit more. Pro tip: who you "get along with" can be very important to the team's productivity: don't write it off as an "irrelevant" qualification. And as long as the remaining person doesn't want to be stuck doing all the work, they won't pick people who aren't capable of doing the work.
|
|
#
?
May 4, 2014 15:52
|
|
|
Does Scrabble exist in French? If so, are accented letters present or are accent grave / aigu just implied where necessary? Ditto German, is there a tile for the double-s thing that looks like an uppercase B?
|
|
#
?
May 4, 2014 18:00
|
|
|
regulargonzalez posted:Does Scrabble exist in French? If so, are accented letters present or are accent grave / aigu just implied where necessary? German Scrabble French Scrabble
|
|
#
?
May 4, 2014 18:04
|
|
|
Interesting, so accents are ignored in French and a mixed solution in German. Obviously this type of game wouldn't work for languages like Chinese or Korean, but I wonder if they have their own language-based board games that would be unworkable in alphabet-based languages.
|
|
#
?
May 4, 2014 18:15
|
|
|
Mak0rz posted:Is there a category of eating disorder* in which your body has trouble identifying when hunger has been sated but your habits are otherwise normal? That seems more like a digestive issue.
|
|
#
?
May 4, 2014 18:57
|
|
|
|
| # ? May 22, 2024 11:14 |
|
|
I worked with a mentally disabled adult for a few months. He had been in a car accident that damaged the satiety part of his brain so he was always hungry. It was actually really really sad. I think it was like some kind of aphasia, think motor or ataxic aphasia but for hunger.
|
|
#
?
May 4, 2014 19:10
|
|