SLA - Response Time

[ricky82]

Hi;
I would like to do a SLA calculation in excel based on month and dates.

Conditions:
Working Days : Weekdays
Working Hours: 7AM - 10PM
Response Time : 2 Hours

If i select the month it should provide me SLA % for the month based on the those responded within 2hrs. Same goes to by date.

Anyone can give me an idea or assistance on this? Its complicated for to figure it out.

Thanks in advance....