hmmm

This is a tough, tortise-and-the-hare question that I figured some of you out there in LJ land might have an answer and/or opinion about:

I’ve been working most of the morning to figure out how to make a formula for a bunch of data I’m sorting in Excel today. Basically, it’s an IF statement that will say that if the time is between 0600 and 1600, it was call it first shift, and if it is between 1601 and 0559, it will call it second shift. And I’m trying and trying and still haven’t found it yet. So here’s the dilemma – I could keep trying and eventually get it because I have no doubt someone in this plant knows the answer – and hey, that person could be me if I could get out of the way of my own thoughts – or go back through every single one of the over 3400 entries, look at the time, and place a 1 or 2 at the shift time.

So my question is what would each of you do? Would you go for the brains or the brawn? Keep thinking a long time for the easy solution, or stop thinking for the long solution? It will be interesting to see.

Anyway, back to work.

Adam

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s