Corton Flyer
New Member
- Joined
- Jan 22, 2010
- Messages
- 15
One of my administrative duties is to keep a record of all of the flying-hours completed by a group of twenty pilots. I've constructed a spreadsheet and entered all of their flying records into it.
At the head of each column I have the date, aircraft type, registration number, pilot name, co-pilot name, other crew name, day flying, night flying, solo, dual, total captain hours, etc.
Whilst that I've completed the easy part of this project and that I can transfer each individual pilots flying-hours into his own seperate logbook (by filtering and copy/pasting into another worksheet), there are three other reports that I'm required to provide:
1. To be able to list the number of flying-hours completed during the previous 7 days (for each individual pilot).
2. To be able to list the number of flying-hours completed during the previous 30 days (for each individual pilot).
3. To be able to list the number of flying-hours completed during the previous 90 days (for each individual pilot).
I can't say that I'm an Excell guru; hence, I'd appreciate any assistance/help that anyone might be able to offer in my trying to resolve the above issues?
Many thanks
John
At the head of each column I have the date, aircraft type, registration number, pilot name, co-pilot name, other crew name, day flying, night flying, solo, dual, total captain hours, etc.
Whilst that I've completed the easy part of this project and that I can transfer each individual pilots flying-hours into his own seperate logbook (by filtering and copy/pasting into another worksheet), there are three other reports that I'm required to provide:
1. To be able to list the number of flying-hours completed during the previous 7 days (for each individual pilot).
2. To be able to list the number of flying-hours completed during the previous 30 days (for each individual pilot).
3. To be able to list the number of flying-hours completed during the previous 90 days (for each individual pilot).
I can't say that I'm an Excell guru; hence, I'd appreciate any assistance/help that anyone might be able to offer in my trying to resolve the above issues?
Many thanks
John