# flight

1. ### Problem with variables misbehaving!

This is my first post on the forum – so hello to you all and many thanks for reading this. I am by no means new to Excel/VBA – but have come up against an issue which is making me feel like a real newbie! I sincerely hope someone can tell me where I’m going wrong. I have an issue with an...
2. ### addition for last 90 days

Hi All. i have a new question. I have to log my flight time so ive created a excell sheet to do this. as part of the competency i have to calulate totel flight time and flight time for the last 90days. So in column A i have the date (formatted 04/06/18) and in Colum G I have the flight duration...
3. ### Is it possible to convert kilos to pounds using Excel *2010*?

The pilot (using a flight simulator,) is programming the "Flight Management Computer" or FMC, and calculating how much fuel he needs, he said to round up to the nearest 100 kilos, then add a 100 kilos. So I'd like to know how to convert those two units. Thanks in advance, HizExceLenCy
4. ### Airport Gate Assignment Problem Using MS Excel

Hi all, I need to solve an Airport Gate Assignment Problem using Excel. The output should include flight number, its respective gate and the time duration for which the gate will be occupied (A picture of which how the output should look like is shown below). Input parameters will be Flight...
5. ### Can this be done in excel?

We have a flight school with about 600 students. There is a training department, a flight dispatch desk, business and financing office, and a couple of others. I want ant to create a relational database with excel ( each person is already familiar with excel) with several tables. I need...
6. ### Conditional Formatting

Hello to you all and weekend wishes. I am devising a Gantt Chart for flying school and ground school. in one row I have the number 18 in certain cells and this represents cadets in ground school in the row beneath I have cells that have 18 in and this determines cadets in flight school and then...
7. ### Combining similar fields into one in a pivot table or ?

My spreadsheet captures information about military basic training - the trainee's name, the squadron number, the flight number, start/end dates, etc. A flight can have more than one TI (Training Instructor), so in any given record, there can be TI1, TI2, and TI3, which are listed by last names...
8. ### Matching text between two column

Hi All, I am looking to search if text column A is preset in column B. How do I go about doing that? Please see the example below Column A Column B Flight to Zante Get cheap tickets Flights to London Plan your trip to the UK Flights to...
9. ### find the connecting flights based on criteria

Hi all, I have been struggling with the following for a number of days now. I want to be able to retrieve the flights that can be connected with Y flight. Basically.. I have Flight nr AA0001 "Y" and based on a departure and arrival list and the minimum connecting time, i want to see which "X"...
10. ### find the connecting flights based on criteria

Hi all, I have been struggling with the following for a number of days now. I want to be able to retrieve the flights that can be connected with Y flight. Basically.. I have Flight nr AA0001 "Y" and based on a departure and arrival list and the minimum connecting time, i want to see which "X"...
11. ### Date Lookup Function - Flight Logbook.

Good Day, I am a commercial pilot and I am developing my own flight logbook sheet (I know there are 1000'ds out there, but I want my own.) I have it fine tuned, I just need some help with what I think is a VLOOKUP function, but I am not sure. So what I have done is I have 2 Tabs, Tab 1 is the...
12. ### Creating a top 10 list of cells with text and duplicates, as well as multiple conditions

Hi! I've searched the forum and found some really useful stuff (thanks a lot!), however, im still not reaching the goal and even though I think I have most of the formulas I need, I still have some problem with the logic. I am currently working on a windows microsoft office excel standard...
13. ### Golf Handicaps Values

I have a list of player names that are divided into 5 Flights (A to E). Each Flight is determined by dividing the list of names with associated scores into 20% or less of the total players. Each player has a previously calculated handicap. I need to find the largest handicap value within each...
14. ### Creating a Flight Schedule

Hi everyone, I wonder if someone could help me, I am trying to create a flight schedule in excel, but I am lost on how to do it, I need to create a calendar of flights. I got a list of flights and details o a row, flight number, two range dates, start date and end date, and days of operation...
15. ### Help me break this down

I have to pull customers flight information from a website and paste it to my sheet but when doing so it puts all of the information into 1 cell. I have tried delimiter function but its hit and miss. I have tried variations of code and formulas but its just a big mess. What i need is to be able...
16. ### Trying to sum a range based on criteria in a table

I'm trying to sum hour many flight hours I have loaded in a spreadsheet. The insurance company wants various totals. The one I'm having trouble with the number of hours in a plane with retractable gear. How can I sum the flight time for all the planes that have retract time? I tried a SUMIFS...
17. ### INDEX / MATCH Formula with multiple conditions

Hi there, I have 2 data sets: Dataset 1 (Flight Table) <tbody> Flight Number Date Day Departure Time Arrival Time 19020 05/10/2017 Wednesday (formula) (formula) </tbody> Dataset 2 (Flight Schedule) <tbody> Flight number Start date End Date Departure Time Arrival Time Monday Tuesday...
18. ### Scheduling

I am creating a schedule for instructors, but there are specific parameters such as a requirement that there must be a 24 hour break in a 7 day period. I create the schedule with names in the far left column and the days of the month in the top row from left to right. I would like a conditional...
19. ### Need an Excel Freelancer to help with dynamic flight data

I maintain an Excel spreadsheet for large group flight travel arrangements. I manually enter all of the basic data for each person including the flight codes and scheduled arrival times. I need to hire somebody to complete my spreadsheet with live data being pulled from public websites that...