Man-hours formula?

**RetSurfer** · 02-21-2013, 07:03 PM

Need some help please?
I have a number of jobs to do that I can get # of man-hours from. Say total, in-house orders = 2650 MH.
I want to see how long this will take dependent upon how many people I put to work on them.
So in column A-PEOPLE I go down the rows with 5,6,8,10,12,14,16,18,20….
The next 3 columns need to display MAN-HOURS, DAYS, WEEKS.
We work 8 hour days 5 days a week.
What formulas should I use and how to format the cells?

Thanks
Mark

**p24leclerc** · 02-21-2013, 08:01 PM

See attached file.
I think you want the HOURS in the first column instead of the man-hours which is a constant here.
Hope this helps

**RetSurfer** · 02-21-2013, 08:54 PM

Originally Posted by p24leclerc

See attached file.
I think you want the HOURS in the first column instead of the man-hours which is a constant here.
Hope this helps

Thank you, you're correct, I agree its hours.

Maybe I wasn’t clear. I would like to show in DAY column #days/hours, like 10/2 and weeks show #weeks/days like 3/2.
Hope I'm clear....

Thanks again!

**p24leclerc** · 02-21-2013, 09:10 PM

It was not mentionned in your first post.
Here it is. I rounded the remaining hours or days. If you want the fractions, remove the ROUND function from the formulas.