## Formula to take into Account Working Hours and Weekends

## Formula to take into Account Working Hours and Weekends

(OP)

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:

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

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

## RE: Formula to take into Account Working Hours and Weekends

-LB

## RE: Formula to take into Account Working Hours and Weekends

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

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