Calculate Business hours between time

[CLKCLK]

I am trying to calculate the DAYS:HH:MM:SS: between 2 timedate fields <startdatetime> - <enddatetime> = <tickettime>. (So if a ticket was opened on Friday at 4:00:00 pm and closed at 8:30:00 am on Monday the time elapsed would be 0 days 1 hour 30 minutes 0 seconds.)

The problem I am having is that I need to only calculate between our business hours M-F 8-5 and also need to eliminate weekends and federal holidays.

Any help would be appreciated.

Thanks

Coady

 

[lbass]

Try Ken Hamady's solution:

http://www.kenhamady.com/form13.shtml

-LB