Crazy Hard DateDiff Function

[plextor]

I have two database fields that I need to perform a DataDiff fucntion on, however I also need to factor in the difference only if it falls within the business hours. For example if a ticket is open on 1/1/2005 12:00pm and closed on 1/2/2005 12:00pm. The caluculation should return a value of 12 hours 0 minuits (or something simiar) and not 24 hours.... I have racked my brain for hours trying to figure this one out. Any ideas?

{Created_on} - (datetime field)
{Closed_on} - (datetime Field)

The business hours are Monday to Friday 6am to 5pm.

Thanks for the Help!

Brian

 

[hneal98]

convert to hours and delete all the hours from 5:01 pm through 5:59 am.

 

[plextor]

Any idea how i can accomplish this in a formula?

 

[plextor]

Found it in the fact section:

The solution is found in FAQ767-5430

Thanks for your help.