Chaining IF Fonction

[Born2Fly]

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.

Please Login or Register  to view this content.

Duty time.jpg

I am quite new to excel. Any help apreciated.

Thanks

[mellowmarshall]

If you post a copy of that worksheet it would help.

[Born2Fly]

There you go still working on the 30 and 90 days formula...

[mellowmarshall]

I take that back, I didn't understand everything you needed at first. Still working.

Please Login or Register  to view this content.

Edit: Got some progress. Trouble is, match() is matching the first "0" value in the 30, 90, and 365 day periods so we end up adding more flight days than necessary. Not sure how to make it match the LAST occurrence of a value within a range, so needs more tweaking.

[Born2Fly]

I've added a column called ''CONSECUTIVE DAYS OFF'' it may simplify the formula.