# Formula to calculate workdays based on differing hours during the week

#### NeoFax

##### New Member
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.

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Replies
8
Views
918
Replies
8
Views
212
Replies
3
Views
305
Replies
28
Views
937
Replies
4
Views
839

1,195,687
Messages
6,011,153
Members
441,589
Latest member
tommatwalker

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back