Calculate Project Workday End Date and Time Based on Duration
Calculate Project Workday End Date and Time Based on Duration
I need to calculate a project’s end date and time based on duration (measured in labor hours). The constraints are a 40 hour work week (no evenings, weekends, or over time) and it cannot include holidays. The attached spreadsheet includes a second tab that lists the company holidays that cannot be counted. However, I’m okay with using Outlook/Excel’s standard holiday list instead for simplification. Any guidance on how to calculate this end date will greatly be appreciated!
nrschmid
Please find the answer in the file attached below.
NRS Workday End Date-Time Based on Project Duration-1
Son Yorumlar