I need a formula that calculates how many workdays it would take to accomplish a task given the tasks duration in hours and each day may have a different time frame. Ex. I have 1042 hrs to accomplish a task with 2 employees. Let's say they are planned to work 10 hr days monday thru friday and 8 hr day on saturday. I want to know how many workdays this will be and how many weeks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula to calculate workdays based on differing hours during the week
- Thread starter NeoFax
- Start date
