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