Help with Completed Date Formatting in Calculated Column

[Monique Millan]

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! 

[#2 · Accepted solution]

@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...

[#3]

Very Helpful - Thank you!!!