Sorry, I'm not sure if it is possible or not, but i envisioned the equation to be something on the lines of

(lookup name from B2 in "RAW" IF is between time frames A2-A3, IF IS then calculate time in different States )(With time in states calculate the % of which is productive, and refer back to Sheet "Selection in A2") Repeat for each time frame.