In one column, I have a cell (B11) where any random number can be input for
college hours earned. Each 30 hours equals 1 year (C11). I am trying to
figure out what formula to use in C11 to get this answer.

Thanks

One way is to put this in C11
=ROUNDDOWN(B11/30,0)


"jt4lsu" wrote:

In one column, I have a cell (B11) where any random number can be input for
college hours earned. Each 30 hours equals 1 year (C11). I am trying to
figure out what formula to use in C11 to get this answer.

Thanks

=B11/30
"jt4lsu" wrote in message
...
In one column, I have a cell (B11) where any random number can be input
for
college hours earned. Each 30 hours equals 1 year (C11). I am trying to
figure out what formula to use in C11 to get this answer.

Thanks

Hi,

In cells C11
=B11/30
Scroll down or copy down these formulas
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"jt4lsu" wrote:

In one column, I have a cell (B11) where any random number can be input for
college hours earned. Each 30 hours equals 1 year (C11). I am trying to
figure out what formula to use in C11 to get this answer.

Thanks