Calculating Drops per hours

G

gary66

In one cell I have a number: say it's 46, which is total Drops for th
day.
In another cell I have total hours worked for the day of:44:00:00.
The total drops of 46 took 44 hours to do, which averages 1.04.
In another cell I have a formula to calculate this, but it give
me:25.09.
How do I put in a formula which will say 1.04?
:
 
N

Nikos Yannacopoulos

Gary,

It has to do with the formatting of the hours cell; the cell is currently
formatted as Time, and Excel interprets this value as 01/01/1900 20:00:00,
internally represented as 1.833 in Excel, thus 46/1.833 = 25.09! Change the
cell formatting to general or some number format and put a plain 44 in the
cell, and you'll get the right value.

HTH,

Nikos
 
B

Bob Phillips

Format the cell as General, as it is showing time value now.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top