Forum Discussion
cellardorian
Dec 04, 2019Copper Contributor
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...
mathetes
Dec 06, 2019Gold Contributor
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.