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!
Bookmarks