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...

=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...

Surely, if you have the total in A20, the formula would be =A20*60 ? If you
have 1 in A20, that will give you 60.
2 = 120 etc?

--
kassie

never stop learning




"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...

Thank you so much... I knew it had to be easy, but could not get my brain to
work!

This was great!!

"Kassie" wrote:

Surely, if you have the total in A20, the formula would be =A20*60 ? If you
have 1 in A20, that will give you 60.
2 = 120 etc?

--
kassie

never stop learning




"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...

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...

Pleasure is all mine!

--
kassie

never stop learning




"NKDodd" wrote in message
...
Thank you so much... I knew it had to be easy, but could not get my brain
to
work!

This was great!!

"Kassie" wrote:

Surely, if you have the total in A20, the formula would be =A20*60 ? If
you
have 1 in A20, that will give you 60.
2 = 120 etc?

--
kassie

never stop learning




"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...