Forum Discussion
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.
Currently I have the below as the Calculated formula, but need to get the hours correct.
=TEXT([Completed Date]-Created,"h:mm")
Thank you!
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
2 Replies
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
- Very Helpful - Thank you!!!
