I need a formula for excel that will add each seven day period up, and give
me the total for each seven day period. for example, a driver is not allowed
to work for more than 60 hour during any 7 day period. therefore, in case of
audit, i need to have the total for each 7 period continuously without having
to adjust the formula(which would thereby erase the result and defeat the
purpose.) so in simple terms, i need to calculate days 1-7, 2-8, 3-9,
4-10,5-11 etc. the important thing is that all the results are displayed, so
that i know that they are under 60 hours