Results 1 to 7 of 7

Calculating Flight Time Per Crew Member

Threaded View

  1. #1
    Registered User
    Join Date
    12-01-2018
    Location
    California, USA
    MS-Off Ver
    2013
    Posts
    5

    Calculating Flight Time Per Crew Member

    I am needing help to calculate flight time based upon if a crew member was present in any seat during the flight. I have been working with the SUMPRODUCT and SUMIFS but keep returning a value of "0". In short, there are 4 positions that a crew member can occupy and if they are in any seat they need to be awarded the flight time. A visual representation of this would be:

    TIME | SEAT A | SEAT B | SEAT C

    1.2 Hr | Person 1 | Person 2 | Person 3
    2.5 Hr | Person 4 | Person 3 | Person 1
    3.8 Hr | Person 1 | Person 5 | Person 2

    Person 1 Total time: "X.X" Hours


    My hope is to build a formula that can tell me how much total flight time each person has logged.

    Thank you in advance!
    Attached Images Attached Images
    Last edited by Raginginferno1; 12-01-2018 at 09:32 AM. Reason: Picture Link Issue

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Flight Crew Scheduling Worksheet
    By T scrilla in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2021, 06:45 AM
  2. Calculating flight hour more than 9999:99
    By perigi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-13-2018, 12:37 PM
  3. Pilot trying to calcualte Night flight time
    By Hernie in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-12-2015, 03:12 PM
  4. How to pull airport flight time from web to excel?
    By andyaf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2013, 09:44 AM
  5. 24 hour lookback - flight time tracker for pilots
    By KenBrown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2012, 07:50 AM
  6. Replies: 2
    Last Post: 01-29-2007, 06:37 PM
  7. [SOLVED] How can I accumulate time in a flight log?
    By RossR in forum Excel General
    Replies: 1
    Last Post: 01-01-2006, 01:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1