Divide a range of cells by a number
It's actually very, very simple.... The chart looks like this:
5/1 5/2 5/5 (etc.)
Tchr 1 55 0 55
Tchr 2 80 80 80
Tchr 3 65 65 30
(etc.)
I am inputting the minutes above each day after school. All I want is for
Excel to divide the numbers by 60 (minutes), thus giving me the fraction of
an hour I worked. So it would be like:
5/1 5/2 5/5 (etc.)
Tchr 1 .92 0 .92
Tchr 2 1.33 1.33 1.33
Tchr 3 1.08 1.08 0.50
(etc.)
"FSt1" wrote:
hi
you didn't say how the range was layed out ie solid, broken, column, row
one way....
=SUM(D3:D7)/60 for a solid block in a column.
another....
=SUM(D3+D5+D7)/60 for broken in a column Note: use this if you have other
number between. if letters between then you can use the first formula
and another....
=sum(D3+D5+C7+r29)/60 for scattered. see note at formula 2.
lots of variations too.
Regards
FSt1
"Kate" wrote:
Hello,
I am entering minutes volunteered across a series of classrooms and dates -
for example, I worked 55 minutes with one class, 85 with another, etc. I want
to divide all these cells by 60 to get a decimal version of hours worked
(this will be cumulative over the next 6 weeks).
Could someone please tell me how to divide a range of cells by one number
(in this case, 60)?
Thank you!
|