# Help calculating difference in time

1. ## 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 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)))

2. ## 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.

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

#### 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