Greetings,

I am trying to find the total time to resolution for HEAT tickets.
The information is extracted from the database via Crystal Reports and
into .xls format. I need a formula that will only calculate the time
to resolution between M-F 0700 (7AM) to 1800 (6PM) and excludes 1800
(6PM) to 0700 (7AM), weekends 1800 (6PM) Friday to 0700 (7AM) Monday
and holidays. I listed an example below.

Date Received Time Received Date Resolved
Time Resolved
2006-12-01 14:57:13 2006-12-04 10:25:20

Basically, the total time to resolution in the example above was
6:29:07 after excluding the weekend hours. Please let me know if
someone has a formula for this situation.

Thanks in advance.

Jason