I have been working on a Help desk management application. Until now I was using the regular calendar for reporting on the days the ticket was created to the date it was closed. The helpdesk department is closed on weekends and public holidays. So when a KPI is developed to calculate Avg. time duration for the ticket to get closed should also take into consideration while calculating weekends and public holidays, i.e. have to exclude those days when calculating:
(Ticket Created Date - Ticket Closed date)
Has anyone come accross such requirement or has an idea of how to design a calendar which takes this constrains into consideration?