Lounge of Tomorrow
Page 9 of 10 « First < 78 9 10 >
Show 500 post(s) from this thread on one page

Lounge of Tomorrow (http://74.208.121.111/LoT/index.php)
-   Egg Head (http://74.208.121.111/LoT/forumdisplay.php?f=13)
-   -   Excel Question #46 (http://74.208.121.111/LoT/showthread.php?t=8380)

Betty 02-16-2012 03:28 PM
Here's a link to the file: http://hemetgraphics.com/ot.zip

Betty 02-16-2012 03:29 PM
Quote:
Originally Posted by Alex (Post 357059)
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 02-16-2012 03:34 PM
Quote:
Originally Posted by Betty (Post 357061)
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 02-16-2012 03:36 PM
Quote:
Originally Posted by Moonliner (Post 357058)
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! :snap: :snap: :snap:

Alex 02-16-2012 03:37 PM
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 02-16-2012 03:38 PM
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 02-16-2012 03:39 PM
Quote:
Originally Posted by Betty (Post 357065)
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 02-16-2012 03:44 PM
Quote:
Originally Posted by Alex (Post 357064)
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 02-16-2012 04:04 PM
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 02-16-2012 04:04 PM
Quote:
Originally Posted by Betty (Post 357063)
There we go! Yay! :snap: :snap: :snap:
You probably already figured this out, but you need to make the same change to cells G13 and G21


All times are GMT -7. The time now is 11:48 PM.
Page 9 of 10 « First < 78 9 10 >
Show 500 post(s) from this thread on one page

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.