{"id":277,"date":"2018-08-23T16:11:16","date_gmt":"2018-08-23T16:11:16","guid":{"rendered":"https:\/\/www.harepoint.com\/Blog\/?p=277"},"modified":"2019-03-22T11:40:08","modified_gmt":"2019-03-22T11:40:08","slug":"calculate-working-time-sharepoint-workflow","status":"publish","type":"post","link":"https:\/\/www.harepoint.com\/Blog\/calculate-working-time-sharepoint-workflow\/","title":{"rendered":"Calculating working time between two dates in a SharePoint workflow"},"content":{"rendered":"\n<p><b>HarePoint Workflow Extensions<\/b> include an action called <b>&#8216;Get Interval Between Dates&#8217;<\/b>. This is a great action allowing you to calculate interval in minutes, hours, days, months or years, as well as optionally exclude holidays according to iCalendar file (.ics).<\/p><p>However, there is a task that you can come across very often in various scenarios, and even \u201cGet Interval Between Dates\u201d action is not really helpful in such cases.<\/p><p>This is a situation when you need to calculate <b>only the working time<\/b> between the two dates.<\/p>\n<p>Now it can be easily done with a <b>new action<\/b> in HarePoint Workflow Extensions \u2013 <b>&#8216;Get Working Time Between Dates&#8217;<\/b>:<\/p>\n\n<p><img decoding=\"async\" src=\"\/Pictures\/Articles\/new_sharepoint_workflow_action_1.png\" alt=\"Get Working Time Between Dates workflow action\"><\/p>\n\n<p>This action is very simple to use since you only need to specify start and end dates. It will automatically take the working days and working hours configuration from <b>Regional settings<\/b> of a SharePoint site:<\/p>\n\n<p><img decoding=\"async\" src=\"\/Pictures\/Articles\/sharepoint_site_regional_settings_2.png\" alt=\"Regional settings on SharePoint site\"><\/p>\n\n<p>In <b>Regional Settings<\/b>, you can flexibly configure working week, working days and working hours:\n \n<p><img decoding=\"async\" src=\"\/Pictures\/Articles\/working_hours_dates_configuration_3.png\" alt=\"Configure working time and dates\"><\/p>\n\n<p>As you can see now, calculating working days or working hours could not be easier than this.<\/p>\n<hr><p>Learn more about <a href=\"\/Products\/HarePointWorkflowExtensions\/Default.aspx\">HarePoint Workflow Extensions<\/a> and over 300 new activities to automate any business process without programming.\n","protected":false},"excerpt":{"rendered":"<p><a href=\"\/Products\/HarePointWorkflowExtensions\/Default.aspx\">HarePoint Workflow Extensions<\/a> include an action called <b>&#8216;Get Interval Between Dates&#8217;<\/b>. This is a great action allowing you to calculate interval in minutes, hours, days, months or years, as well as optionally exclude holidays according to iCalendar file (.ics). The presented article provides you a short &#8216;how-to&#8217; for this issue.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[23,25],"_links":{"self":[{"href":"https:\/\/www.harepoint.com\/Blog\/wp-json\/wp\/v2\/posts\/277"}],"collection":[{"href":"https:\/\/www.harepoint.com\/Blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.harepoint.com\/Blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.harepoint.com\/Blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.harepoint.com\/Blog\/wp-json\/wp\/v2\/comments?post=277"}],"version-history":[{"count":6,"href":"https:\/\/www.harepoint.com\/Blog\/wp-json\/wp\/v2\/posts\/277\/revisions"}],"predecessor-version":[{"id":793,"href":"https:\/\/www.harepoint.com\/Blog\/wp-json\/wp\/v2\/posts\/277\/revisions\/793"}],"wp:attachment":[{"href":"https:\/\/www.harepoint.com\/Blog\/wp-json\/wp\/v2\/media?parent=277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.harepoint.com\/Blog\/wp-json\/wp\/v2\/categories?post=277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.harepoint.com\/Blog\/wp-json\/wp\/v2\/tags?post=277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}