How to query SLA information

I have an Analyst that has asked for the following:  She needs the ability to query/see the difference between date/time created and the date/time first assigned calculated in hours.  The gotcha is that it must not include the time that it was either out of the range of the set calendar or if another status other than active.  Is this easily doable?