Thursday, May 21, 2015

yogi_Compute Cumulative Time From LOGBOOKS!G For A/C Model In LOGBOOK!C For Time Periods In Column A


                                           Google Spreadsheet   Post  #1962
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    May 21, 2015
question  by Matt Volf:
https://productforums.google.com/forum/#!mydiscussions/docs/Gdkry18ZwbA
Need help with a formula for my pilots logbook in sheets.
I need help figuring out a formula that will sum all flight time in a specified model of aircraft during a specified time period.

Example:

I want to sum all flight time in a Cessna 172 in the past 6 months.
---
Here is a link to the spreadsheet.


I am looking for a formula that will total all flight time (Logbook!G)  that was flown in a specific model (logbook!C) within in a specified time (past 30 days, past 6 months, whatever I specify)
--------------------------------------------------------------------------------------------------------------------------------