+ Reply to Thread
Results 1 to 2 of 2

Help calculating difference in time

  1. #1
    Registered User
    Join Date
    08-26-2014
    Location
    Washington, DC
    MS-Off Ver
    2010
    Posts
    31

    Help calculating difference in time

    SUMMARY:
    I think I need something like this, but this function throws the error "Inconsistent formula":
    =IF($B24="","",IF(OR($L24<=3,$L24="r"),IF($I24,TODAY()-$I24,"-"),IF($J24="-","-",$J24-$I24)))

    ---

    I have a spreadsheet laid out as follows:

    Col B is "file name"
    Col E is "age"
    Col I is "date received"
    Col J is "date closed"
    Col L is "current status," with possible values 0-3 as well as some letters

    I have a formula in Col E as follows:
    =IF($B24="","",IF($L24<=3,IF($I24,TODAY()-$I24,"-"),IF($J24="-","-",$J24-$I24)))

    The function works great almost every time. It tells me the age of the file from the time it was received to present--or to the date closed, if closed. When the case is open, Col L is a number. When the case is closed, Col L is a letter.

    The problem is that in one scenario, the case is closed and Col L is letter "r". When this happens, the function flips out, and I'm getting a value of -41897.

    I think I need something like this, but this function throws the error "Inconsistent formula":
    =IF($B24="","",IF(OR($L24<=3,$L24="r"),IF($I24,TODAY()-$I24,"-"),IF($J24="-","-",$J24-$I24)))

    Please assist. Thank you.
    Last edited by jes269; 12-18-2014 at 10:54 AM.

  2. #2
    Registered User
    Join Date
    08-26-2014
    Location
    Washington, DC
    MS-Off Ver
    2010
    Posts
    31

    Re: Help calculating difference in time

    Nevermind! I solved my own problem. I didn't understand that "Inconsistent formula" just means that the formula for that row is not the same as others in the column.

+ 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. Calculating for Time Difference...BUT
    By Miskondukt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2014, 05:34 PM
  2. [SOLVED] Calculating the Difference in Time
    By forexcellence13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2013, 10:56 PM
  3. [SOLVED] Calculating time difference?
    By devpp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2013, 02:31 AM
  4. Calculating time difference
    By TomBP in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-02-2010, 04:59 AM
  5. Calculating time difference between two days capturing the overnight time.
    By Monica_La in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2007, 11:22 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