Division on a totaled number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Thank you so much... I knew it had to be easy, but could not get my brain to
work!

This was great!!
 
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!
 
Back
Top