SkoolofBiz
New member
- Feb 6, 2009
- 1
- 0
- 1
Spreadsheet has Names 
A) Departments B) Total Hours Worked C) total Qty produced D), Total Value produced E) and Date Worked F)
The idea is to set a start date and end date (without filters) and get the average of the units produced per hour. I know this can be done by duplicating the equation twice, once to pull the hours worked by employee, the other to pull the units produced...and then a formula on the Main spreadsheet page to get the right number in the right places.
The real issue lies in only pulling the data from a certain date range so we can view anything from, say, 1/1/09 - 1/31/09 and then put a new start date in and view data from 1/17/09-1/24/09...
A) Departments B) Total Hours Worked C) total Qty produced D), Total Value produced E) and Date Worked F)The idea is to set a start date and end date (without filters) and get the average of the units produced per hour. I know this can be done by duplicating the equation twice, once to pull the hours worked by employee, the other to pull the units produced...and then a formula on the Main spreadsheet page to get the right number in the right places.
The real issue lies in only pulling the data from a certain date range so we can view anything from, say, 1/1/09 - 1/31/09 and then put a new start date in and view data from 1/17/09-1/24/09...
