hour

[Char]

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!

 

[Bob Phillips]

A few things.

Why do you make it text, you can format it however you want?

Even as text, Excel should workout the value okay, unless you have some
other text in the cell as well as the time (e.g. 37.5 hours)



--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Tyro]

Formatting of numbers is for human consumption. You can havea number in a
cell and format it as you want it to appear. For calculations, Excel uses
the number that's in the cell, not the formatted appearance.

Tyro

 

[Ron Rosenfeld]

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!

IT's not very difficult, and has nothing to do with you formatting your entry
as text. But you do have to format the result as a number or as a per cent.

The formula for % of weekly hours available is:

number of hrs available / total weekly hours.

So if:

A1: 28.15 (formatted as text)
B1: 37.5 (formatted as text)
C1: =A1/B1 will give the % hrs worked.
--ron