Forum Discussion
naomi_j
6 years agoFrequent Visitor
Calculate working hours between two dates
I'm trying to calculate the number of working hours/minutes between two dates (ie. excluding non-working hours and weekends). This is the basic format - and I'm trying to find out how long it t...
v-chuncz-msft
6 years agoCommunity Support
You may calculate working hours/minutes since Mon, Feb 24, 2020.
DIFF ( <Base>, <Resolved> ) - DIFF ( <Base>, <Created> )
naomi_j
6 years agoFrequent Visitor
Thanks for your response, v-chuncz-msft. I've not seen this option - are there any articles to explain the function?
What would be the <Base> value here?