Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12

Thread: Flight Time Extraction for 24 hrs, Weekday, and Month blocks

  1. #1

    Flight Time Extraction for 24 hrs, Weekday, and Month blocks



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Flight Time Extraction for 24 hrs, Weekday, and Month blocks

    I am trying to extract the flight time from a leg depart date, leg depart time, arrival date, and arrival time.

    First I would like to gather all minutes of flight time flown from 00:00-01:00 and so on.

    Second, I would like to gather all of the flight time flown on Mondays and so on.

    Third, I would like to gather all flight time flown in January and so on. The below is a snapshot of my data, but I would like to email the snapshot of the actual spreadsheet if someone can help.


    Ex. Based off of the the first flight below (jan 7).. the flight time for the hour block would be around 6 mins for 1200-1300, 60 mins for 1300-1400, etc

    3 hrs and 6 mins for sat (probably use the weekday function, and 3 hrs and 6 min for Jan.


    Click image for larger version. 

Name:	Capture.JPG 
Views:	46 
Size:	72.0 KB 
ID:	2938

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    751
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Do flight times never cross midnight?

  3. #3
    Yes. Totally stumped. Someone gave me this formula for the 24 hour blocks, but it gives me ##### when no time is recorded. THis is an issue when I want to sum the time. Also, the weekday and month are hard to figure out as well.

    =MIN(Q$2+TIME(1,0,0),$J3)-MAX(Q$2,$H3)

    Click image for larger version. 

Name:	12_11.JPG 
Views:	31 
Size:	81.0 KB 
ID:	2946

  4. #4
    Acolyte Mike_Alex's Avatar
    Join Date
    Jun 2014
    Location
    Middle Wisconsin
    Posts
    57
    Articles
    0
    Could you not just put in an ifelse where if J is blank, put a zero in place?

  5. #5
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    751
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Someone gave me this formula
    Does that translates to " I have this same question posted on another forum " ?

  6. #6
    Funny response BC, but I am looking for answers from wherever I can get them. Sarcasm is not an answer.

  7. #7
    Ok, The snapshot is a little confusing. I will post a different one where there is always an arrival time. This still gives me a bunch of #####. Again, the sum function doesn't like this for some reason. Thanks for the help. Click image for larger version. 

Name:	SEFHG.jpg 
Views:	28 
Size:	90.7 KB 
ID:	2949

  8. #8
    Acolyte Mike_Alex's Avatar
    Join Date
    Jun 2014
    Location
    Middle Wisconsin
    Posts
    57
    Articles
    0
    There is a sumif function: SUMIF J is not blank, otherwise, what ever number you would like.

  9. #9
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    751
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Funny response BC, but I am looking for answers from wherever I can get them. Sarcasm is not an answer.
    This wasn't an answer, it was a question, because if so you are displaying total disregard and/or respect for the rules of the forums as well as the time of the very people from which you seek assistance.
    Have a read of this for an understanding, it is a page of this site, included as a link in the rules of numerous other Excel sites.

  10. #10
    Point taken. But, how am I to know that the talent level here is similar elsewhere. I am looking to complete this study of my own free time to potentially reduce the aviation mishap rates of American USN/USMC servicemen/women. Now that you have sufficiently educated my on excel forum etiquette, can we get to a solution to the above.

Page 1 of 2 1 2 LastLast

Tags for this Thread

Posting Permissions

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