Calculate total project time
Oyaji
-
Redbart Posted messages 20952 Registration date Status Member Last intervention -
Redbart Posted messages 20952 Registration date Status Member Last intervention -
Hello,
I am currently training to become a quantity surveyor for structural works and plastering. This training is on a work-study basis, and I need to create sub-details in Excel for basic works (e.g., foundations, walls, partitions, etc.) since there are no such tools in the company. To make matters worse, I am a beginner at Excel! So here is my problem:
I am making my sub-detail table, with formulas, data entered based on the work and unit labor times.
I have created a second table next to my sub-detail to calculate the total supply price (order forecast), total labor, and total time based on the quantity to be completed.
For example:
100m² of partition = Total supply price = Duration of the site
(detailed quantities)
In my sub-detail, I have summed the labor times (unit in 1/100th of an hour), but I cannot deduce a unit time for the work, let alone an overall site time.
Here’s how I would like it to appear:
Unit time for the work Overall site time (7.8h workday, not 24!!)
hh:min jj:hh:min
I am currently training to become a quantity surveyor for structural works and plastering. This training is on a work-study basis, and I need to create sub-details in Excel for basic works (e.g., foundations, walls, partitions, etc.) since there are no such tools in the company. To make matters worse, I am a beginner at Excel! So here is my problem:
I am making my sub-detail table, with formulas, data entered based on the work and unit labor times.
I have created a second table next to my sub-detail to calculate the total supply price (order forecast), total labor, and total time based on the quantity to be completed.
For example:
100m² of partition = Total supply price = Duration of the site
(detailed quantities)
In my sub-detail, I have summed the labor times (unit in 1/100th of an hour), but I cannot deduce a unit time for the work, let alone an overall site time.
Here’s how I would like it to appear:
Unit time for the work Overall site time (7.8h workday, not 24!!)
hh:min jj:hh:min
Configuration: Windows XP Internet Explorer 7.0
3 answers
-
For the sub-detail example:
A1 - MO installation of metal framework: 0.2h/m2
A2 - MO installation of insulation: 0.2h/m2
A3 - MO installation of drywall: 0.2h/m2
A4 - MO tape+finish: 0.2h/m2
A5=sum(A1:A4)
A5=0.8
I want it to show: 00h:48min:00s and not 19:12:00 !! (cell format: hh:mm:ss)
Example for global duration estimation of the construction site:
A7 - Quantity of site: 458.21m2
A8=A5*A7
A8=366.568
I want it to show: 46d:07h:00min (this means almost 48 days of work for a worker who works 39h a week)
Thanks in advance!!
