Hi I'm Eric.

I've been trying to make excel sheet for tracking my flight duty times, flight times and Off days.

Here's the thing. We have flight time limit to 60h/7 days, 150/30 and 450/90. I can reset thoose to zero by take 5 consecutive Off days... So after there is 5 Off days, the ''FLIGHT TIME LAST 30 DAYS'' Would need to start after le last days of the 5 consecutive Off days. I haven't yet figures out how to do this without using a bunch of ''IF'' one after another.

Formula: copy to clipboard 
=IF(SUM(J26:J30)=5,E31,IF(SUM(J25:J29)=5,SUM(E30:E31),IF(SUM(J24:J28)=5,SUM(E29:E31),IF(SUM(J23:J27)=5,SUM(E28:E31),IF(SUM(J22:J26)=5,SUM(E27:E31),SUM(E2:E31))))))


Duty time.jpg

I am quite new to excel. Any help apreciated.

Thanks