I have a pilot friend who needs to calculate his flying hours. After every seven days, he needs to know if he has crossed the limit of 30 hours. So I have created an Excel sheet for him where he can enter the number of hours he has flown every day. How do I set a formula to add the hours for every seven days and then another formula that tells him the number of hours left for the 30-hour limit or whether that limit has been crossed.
There is a different limit for every 30 days as well, but once I know the 7-day calculation, I will be able to extrapolate that to calculate the 30-day figures.