Division on a totaled number

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

Kassie

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?
 
G

Guest

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

This was great!!
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Sumproduct 0
Excel Subtracting multiple columns from another column 3
Simple Division 1
Add/Subtract columns from tab to tab in same file 3
Access Query problem 1
Total cells of one column based on the values in another column? 10
How do I update a formula automatically without hitting button F9 1
totaling rows 4

Top