Forum Discussion

Monique Millan's avatar
Monique Millan
Copper Contributor
Mar 14, 2019
Solved

Help with Completed Date Formatting in Calculated Column

In search of a formula that will calculate the working hours Monday-Friday , 8 hour days. Excluding weekends. The reason is, I am looking for real duration of project during working hours.  Currentl...
  • ellan1537's avatar
    Mar 19, 2019

    Monique Millan Refer to the below article and see if that helps.

     

    https://social.msdn.microsoft.com/Forums/office/en-US/eddee5d6-e714-4ab2-a98f-735a1016ae60/calculate-number-of-hours-between-two-date-field-excluding-saturday-and-sunday?forum=sharepointdevelopment 

Resources