Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averages/Percentages
I have four lanes open per hour for sixteen hours. Each lane records a total
number every hour. I need an average per hour for sixteen hours and I need a percentage for the amount of surveys conducted for each lane per hour for sixteen hours. (i.e. if each lane recorded a total number of 15 for the first hour this would equal to 60 between all four lanes for one hour. If 60 surveys were conducted between all four lanes within that first hour this would be 100% surveys conducted). Please help. John |