Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating duration between two date/time fields, excluding weekend/holiday/overnight hours

Bharat Kavade
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 6, 2018

We have two date/time fields which are filled in our workflow step. We want to calculate the duration between these two date/time fields using script in calculated number field.

However, the catch is that the duration should exclude the weekends, holidays and 9 PM to 9 AM everyday.

Can anyone suggest a script I can add to the calculated number field for duration?

0 answers

Suggest an answer

Log in or Sign up to answer