I'm looking to calculate the Labor rate for a group of 9 employees (TotalHoursWorked/TotalHours). I need to find how to calculate the total work hours in a given month. The calculation will consist of: Monday thru Friday, 8 hrs a day times 9 employees which is 1656hrs in 23days for the Month of August. I already have a calculation to obtain "TotalHoursWorked" now I just need this calculation for the denominator.

I've found this calculation but not to sure how to get this to work since this will only give me the number of days.

Let([

D = TotalHours;

startDate = Date ( Month ( D ) ; 1 ; Year ( D ) ) ;

endDate = Date ( Month ( D ) + 1 ; 0 ; Year ( D ) )

];

5 * Int ( ( EndDate - StartDate ) / 7 ) +Middle ( "0012345501234544012343340123223401211234010012340" ; 1 + 7 * (DayOfWeek ( StartDate ) - 1 ) + DayOfWeek ( EndDate ) ; 1 )

)