Need help calculating time ahead max end of range and low end of range

Hi everyone,

I am working on putting together some data for work. What I am trying to do is show the time ahead of standard processing. For example, I have that normal processing is for example 180-240 days (I have other range sets). I have a cell calculating how long the process took in days, and what I want to do is show a cell where I show how far ahead my processing is over the high end and low end of the above range.

Data:

G Total Time Processing (based on a calculation of starting at C and ending at E)
H is where I want to do my calculation

So what I want in H is that G is X days (from minimum) to Y days (from maximum) to show that my data is ahead of normal.

Like I said I have about 8 sets of range data for different types of work being processed on one spreadsheet.

Please read the banner at the top of this page on how to attach a worksheet

If I understand correctly then perhaps this will help.
I made eight helper columns.
1. Four display the low and high values in the App ranges using: =--LEFT(U2,3) and =--RIGHT(U2,3)
2. Four display the low and high for the location in the row using: =INDEX(W$2:W$5,MATCH(MID($B2,4,2),$T$2:$T$5,0))
Column F is populated using: =O2-E2&" - "&P2-E2
Column L is populated using: =Q2-K2&" - "&R2-K2
If I have misinterpreted the request then please fill in a few of the values in columns F and L so that we can get a better idea of what you want.
Let us know if you have any questions.