I have a sheet for employee's with the number of hours worked in a week in
one column (example 37.5) and the number of hours available (example 28.15)
in another - I have the format for each set at text so excel won't reformat
the data.

Now, I need to know the % of weekly hours that someone was available and I
can't get the formula to calculate correctly. I'm assuming that it is
because of the format of the original cells ?? any ideas? I don't want to
change how the hours are recorded (about 100 employees) imput their own
hours. The # of hours available is pulled from our phone program. Plus, I
would rather not figure out the % myself and I'm thinking that Excel can do
this for me!
Please help!