View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Azza1986 Azza1986 is offline
external usenet poster
 
Posts: 1
Default 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