Results 1 to 13 of 13

Convert Time to Decimal with Custom Time Matrix

Threaded View

  1. #1
    Registered User
    Join Date
    02-03-2016
    Location
    Allentown, PA
    MS-Off Ver
    2010 Mac
    Posts
    17

    Post Convert Time to Decimal with Custom Time Matrix

    I am working on a formula to convert flight time into tenths of a decimal but with a catch -there is always a catch, isn't there. The client has specific ranges for which to round up:

    :00 - :02 = .0
    :03 - :08 = .1
    :09 - :14 = .2
    :15 - :20 = .3
    :21 - :26 = .4
    :27 - :32 = .5
    :33 - :38 = .6
    :39 - :44 = .7
    :45 - :50 = .8
    :51 - :56 = .9
    :57 - 1.02 =1.0

    When I put my start time in D5 and finish time in D7, I want the total flight time with the above variables to be displayed in E5. I found some formulas that seemed like they were close, but I can't account for the non-standard rounding - the first group it's two min, the rest are 5 min groups.

    Any ideas??
    Last edited by john.fries; 02-03-2016 at 12:02 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert time to decimal
    By ExpressTyping in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-29-2013, 11:27 PM
  2. Replies: 22
    Last Post: 09-15-2013, 10:43 AM
  3. [SOLVED] Need to convert time to decimal
    By JessicaW in forum Excel General
    Replies: 2
    Last Post: 10-02-2012, 05:33 PM
  4. Convert decimal to time
    By jonasbirk in forum Excel General
    Replies: 1
    Last Post: 09-07-2011, 01:08 PM
  5. Help me to convert time ti decimal value
    By rickybhai in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-29-2011, 08:56 AM
  6. Excel 2007 : Convert decimal to time
    By jbritt in forum Excel General
    Replies: 7
    Last Post: 01-03-2010, 08:10 PM
  7. [SOLVED] Convert Time Decimal to standard time.
    By GTVT06 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2006, 12:30 PM

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