Business (Working) Hours Calculator for Microsoft Dynamics CRM

View Our Posts

CRM workflows can add time (days and hours) to a date/time field. To create a task 4 hours from now, let's say: Friday 4:00PM, the calculated time is 8:00PM the same day, which is outside business hours ( Monday-Friday 8:00AM till 5:00PM). Adding 4 business (working) hours to Friday 4:00PM is actually, Monday 11:00AM. Moreover, if Monday is a Public Holiday then adding 4 business hours to Friday 4:00PM is Tuesday 11:00AM.

Dynamics Workflows in Microsoft Dynamics CRM solution now includes Business Hours functionality, in addition to text, maths, date, and stats on the fly functions. A trial version can be downloaded from:

Here are two examples where you will use Dynamics Workflows Business Hours functionality:

Follow up Activity
Whether you have just completed a meeting, a phone call, sent an email, or submitted a price quote, it is best practice to follow it up within 2-4 working days. These are working days and we don’t wish to include weekends and public holidays. Dynamics Workflows includes a Dialog that displays a pick list for the user to select the number of days for follow up and based on the user’s selection it calculates the due date based on working hours, and creates a follow up activity for the due date & time.

Response and Resolution Times for Service Level Agreement (SLA)
Service providers need to comply with Service Level Agreement (SLA) contracts that determine the maximum time allowed for first response to an incident and the maximum time allowed for resolving a case. In Dynamics CRM the SLA contract is linked to a Contract Template, which can either be normal business hours (like:9AM-5PM), extended business hours (like: 7AM-9PM) or 24x7. Dynamics Workflows can update the Response By & Resolve By fields in the case entity, as well as calculate the actual time it took to first respond to a case and the actual time to resolve it, based on the SLA Contract and Contract Template of the customer.

Dynamics Workflows comes with two examples to demonstrate how to create workflows to calculate the number of business hours between two dates and how to add business hours to a date/time field.

Click here and watch "Business Hours"  video

Workflow Example – Dialog to create follow up phone call after completed appointment


We use a Dialog with prompt text and a response type: Option Set (picklist)

The picklist has 2 fields: Label and Value.

This workflow is using a contract template of 9 working hours Monday to Friday, therefore for the label: “3 working days” we enter “27” as value.


The next step of the workflow is using the Math Function of Dynamics Workflows to convert the value of the selected response (“27”) from text string to a number, as only numbers are accepted as business hours input in Business Hours function.


In Business Hour Function we select:
Contract Template: Business Hours
Date1:  the time the process is executed
Business Hours to add: the result of converting to number the value selected in the Prompt and Response Page

The below image shows the working hours as set in the Contract Template:

WF-Contract Templ

The final stage is to create a phone call with a due date, updated by the returned result of “Calculated new Date and Time”

WF-Phone call

Download Trial Version:





by DNN Integration Dynamics CRM

Show Buttons
Hide Buttons