Forum Discussion

naomi_j's avatar
naomi_j
Frequent Visitor
6 years ago

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...
Need Help
naomi_j's avatar
naomi_j
Frequent Visitor
6 years ago

Thanks Greg - it seems the Net Work Days option should be close to what I want.  Although I will have the same issue as the other user who commented in the thread (start and finish times potentially occurring out of work hours).  Was there a solution for avoiding the negative numbers?

 

Thanks again!

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    6 years ago

    naomi_j 

     

    You may calculate working hours/minutes since Mon, Feb 24, 2020.

    DIFF ( <Base>, <Resolved> ) - DIFF ( <Base>, <Created> )

     

    • naomi_j's avatar
      naomi_j
      Frequent Visitor
      6 years ago

      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?