Forum Discussion
Help Building a Formula to Roll over cumulative hours
Hello!
I am trying to build a time-sheet that will allow hours to automatically roll over to the next day, and then each week, to the next week.
What we need is IF C12>8, then that amount is added to the next day, and to continue rolling over.
Each day cannot go over 8 hours, and each week cannot go over 44 hours, at the end of the pay period anything over 108.33 hours must go into banked overtime.
Would appreciate any help writing these formulas!
1 Reply
cellardorian You'll get answers to your questions far more readily (and more to the needed point) if you upload a sample of the workbook you have currently.
Part of what we need to see is the context, not just your description of what you want a formula to do. The reason?--there might be a better way to organize your data in the first place; there might be other things to do to make a more powerful and effective solution than just identifying hours over 8 per day, over 44 per week, etc.
