+ Reply to Thread
Results 1 to 13 of 13

Convert Time to Decimal with Custom Time Matrix

Hybrid View

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

    Re: Convert Time to Decimal with Custom Time Matrix

    Hello again, I've been using the formula and everything was good until someone found an anomaly. When I go through the times and check the formula it works as advertised. However, someone found that depending on the start time used, it skews the result by .1 - However, it's not predictable and makes the spreadsheet completely unreliable. To make matters worse, I had to move the spreadsheet to Google Sheets using the same formulas and it has the same problems. I sanitized the spreadsheet and cant figure out how to post it here for review and help.
    Attached Files Attached Files
    Last edited by john.fries; 03-14-2016 at 08:44 AM.

+ Reply to Thread

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