Work Time / Available Hours Calculations and Spreadsheet

Below are calculations for:

- Work Days / Work Hours based on Excel's Networkdays Formula and comparison to Old Method

- Calculcations for Future Fiscal Years

- Max Worktime Calculations

- Estimating Causal Worktime %

 

A copy of the spreadsheet with the examples and formulas can be downloaded below: