Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total percentages
I want to work out the total percentage of 2 sums,
For example Matthew worked 5 hours stacking shelfs, in this time he stacked 40 shelves, his target was to stack 10 shelves per hour so his current percentage would be 80%. Matthew then works 3 hours cleaning shelves, in this time he cleaned 45 shelves, his target was to clean 15 shelves per hour so on this job he is hitting 100%. What I need to know is what formula I need to use to calculate his overall percentage for the day, taking into account the duration he spent on each job???? Thanks to all who maybe of help. Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
Total column changes colors when total equals sum of other columns | New Users to Excel | |||
calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |