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.
Bookmarks