Formula to take into Account Working Hours and Weekends

[keenoafc]

Hi

I need to calculate the date/time difference between two date fields in my database. I can do this using the DateDiff function.

However I need to also factor into this datediff formula. Working hours and weekends.

So if the working hours are 08:00am to 17:00pm Monday to Friday (CET Timezone).

Can i amend the DateDiff formula or use a different formula which will only calculate the difference between the two date/time fields taking into account the above Working Hours only. Effectively stopping the clock and not counting any Hours/mins outside of these times.

My Current DateDiff formula is: datediff("n", {BMCServiceDesk__Incident__c.BMCServiceDesk__openDateTime__c}, {BMCServiceDesk__Incident__c.BMCRF_Coty_Resolved_Date__c})

THis brings me back the value in Minutes. Not sure if there is such a way to convert this to also display the difference in Days, Hours and Minutes.

Appreciate any tips or insight here

Thanks

 

[lbass]

Look at the FAQs on this topic. Try Ken Hamady's "Common Formulas" FAQ to see his working days formula, for example.

-LB

 

[AndyMc]

Here are links to Ken Hamady's formula's for Work Days and Work Hours that Linda is referring to:

http://www.kenhamady.com/formulas/form01.shtml

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