Results 1 to 12 of 12

Forcing time to round to single decimal (flight calculator)

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2020
    Location
    noneya
    MS-Off Ver
    Excel 2016
    Posts
    7

    Question Forcing time to round to single decimal (flight calculator)

    I need to log flight time. I currently have it set so that I can enter a date and time 5/5/2020 and say 19:03 for take off and landing is 5/6/2020 at 04:23. Which results in 9.3 hours. 19:03 to 04:23 is 9 hours and 20 mins. I need it to say 9.4 (19-24 mins = 0.4 from chart below), not 9.3.

    I need to force the times into this format:

    1 to 6 = 0.1
    7 to 12 = 0.2
    13 to 18 = 0.3
    19 to 24 = 0.4
    25 to 30 = 0.5
    31 to 36 = 0.6
    37 to 42 = 0.7
    43 to 48 = 0.8
    49 to 54 = 0.9
    55 to 60 = 1

    This is slightly different that the way Excel calculates time. If I fly for 1 min, excel will see that as 0.01667 and rounds it to 0.0. But I need it to say 0.1 even for only 1 min of flight.

    I hope this makes sense and that I have provided enough detail. I feel that I am almost there, I just need a little boost to get to the end. Example is attached. Thank you for any help!
    Attached Files Attached Files
    Last edited by bmwflyboy; 05-02-2020 at 09:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculating Flight Time Per Crew Member
    By Raginginferno1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-02-2018, 04:41 AM
  2. Calculate Aircraft Parking Time but with same flight Registration
    By vba1234 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-04-2018, 05:23 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