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