Calculate Time during different sets of work hours
 

I am trying to calculate the total time it takes to resolve an issue
within an organization that has a 24 x 5 work schedule during the week
and 9-5 hours on the weekend. I want to make sure that the non-work
hours on the weekend are not calculated.

Does anyone have a formula for the example below?


Submitted Date Resolved Date
10/15/08 10:51:20 AM 10/25/08 02:54:32 PM

Thanks in advance,

LJ