Good afternoon
I'm attempting to transfer all my pilot hours into a spreadsheet to simplify job applications where I have to provide hours flown in x timeframe, usually 7 days, 30 days, 90 days, etc.
I have two sheets, one being "Flight Logbook" and the second being "Totals".
Within Flight Logbook I have multiple columns - dates (column B starting Row 8), single engine hours flown (labeled SEL, column H starting Row 8), multi engine hours flown (MEL), etc.
On my Totals sheet I have different rows defining different criteria I'm trying to narrow down. For example on one row I want to calculate "single engine hours flown within" the last 7 days, 30 days, 90 days, 6 months, etc. These can be hardcoded into the formula as employers don't stray from these types of time frames:
However all I keep getting in return is "0". Where might I be going wrong? It might be worth noting that some rows might have a blank cell - you can't fly a single engine plane and a multi engine plane at the same time
I have attached a screen shot of the Flight Logbook sheet.
Any help appreciated!
Bookmarks