View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
NKDodd NKDodd is offline
external usenet poster
 
Posts: 4
Default Division on a totaled number

Thank you so much for your help... I knew it had to be easier than I was
trying to make it.. This was great help!

"Don Guillett" wrote:

=sum(a1:a21)/3
???
--
Don Guillett
SalesAid Software

"NKDodd" wrote in message
...
I have a worksheet where I have a column that has number of participants to
attend a class, a column that has the length of class and then a column
that
has a formula to multiply the number of participants times the length to
get
a total amount of time trained (example 15 people in a one hour class is a
total of 15 hours). The column with the total amount I have auto summed
so I
get a total number of hours for a month. I want to know take that total
for
the month and divide it so I know how many minutes that breaks down to. I
can not get any formula to come out right for me.

I know this must be something simple I am missing, but can not get
there...
Any help would be great.

Thanks for your time and assistance...