Sunday, May 11, 2014

yogi_Compute ProjectCompletionDate Given Number Of Daily Work Hours And ProjectStartDate


                                         Google Spreadsheet   Post  #1634
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-10-2014
post by: Yogi Anand -- question by John Otto (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/docs-community/chrome-browser/no/0Svv1zed5bM)


question by John Otto:

Scenario
We have an amount of hours a project will take. 1,546.7787 man hours
Labor days are Monday through Friday from 7:00 am to 4:00 pm and Saturday from 7:00 am to 11:00 am
We need to know if 1 person or more is used how many months and days it will require to finish the project.

John
------------------------------------------------------------------------------------------------------------------------------