NewStranger
12-07-2006, 07:53 PM
Good evening, All....I have searched the KB, and haven't found anything quite like this.....
I am attempting to make a spreadsheet that will total the daily hours and give an accumulated value for the past 7 days, on a "rolling 7 day basis"
Where I am running into trouble, is when I try to allow for a condition "reset" and have the formula recalculate from "0", or more properly...from the "reset" point....
Any help, suggestions, direction to look for a solution; would be greatly appreciated....
I have attached the worksheet which will hopefully help explain what I am trying to do....
Many thanx.....
I am attempting to make a spreadsheet that will total the daily hours and give an accumulated value for the past 7 days, on a "rolling 7 day basis"
Where I am running into trouble, is when I try to allow for a condition "reset" and have the formula recalculate from "0", or more properly...from the "reset" point....
Any help, suggestions, direction to look for a solution; would be greatly appreciated....
I have attached the worksheet which will hopefully help explain what I am trying to do....
Many thanx.....