Excel Question #46

[Betty]

Here's a link to the file: http://hemetgraphics.com/ot.zip

[Betty]

Originally Posted by Alex

So the seven consecutive day rule only applies to calendar week? Working 8 days in a row from Wednesday through the next Wednesday would not?

That's a good question - let me verify. (I'm pretty sure the wording "work week" doesn't mean any old days.)

[Moonliner]

Originally Posted by Betty

That's a good question - let me verify. (I'm pretty sure the wording "work week" doesn't mean any old days.)

With the one change made to cell G5 it seems to work fairly well.

[Betty]

Originally Posted by Moonliner

Cell G5 should read: is =IF(SUM(B5:F5)<40,MIN(MIN(8,40-SUM(B5:F5)),G4),0)

What is the formula for cell G6 and G7?

There we go! Yay!

[Alex]

Though the rules given above never mention any trigger of overtime at 40 hours so I'm not sure why that is appearing in the formulas.

[Betty]

I'm still waiting for verification on the question but I'm 99% sure that it's working the way it should.

Thank you so much! really and truly. On a day where I've been unusually busy, had numerous car issues and a few other things pop up, you have helped tremendously.

[Moonliner]

Originally Posted by Betty

I'm still waiting for verification on the question but I'm 99% sure that it's working the way it should.

Thank you so much! really and truly. On a day where I've been unusually busy, had numerous car issues and a few other things pop up, you have helped tremendously.

Glad to help.

[Moonliner]

Originally Posted by Alex

Though the rules given above never mention any trigger of overtime at 40 hours so I'm not sure why that is appearing in the formulas.

That is a good question, I assume it's because five 8 hour days = 40 hours.

[Alex]

I can't see the spreadsheet from work but would be interested in seeing the formulas in the other cells.

But if it is working, then good enough.

[Moonliner]

Originally Posted by Betty

There we go! Yay!

You probably already figured this out, but you need to make the same change to cells G13 and G21