Calculating Drops per hours

[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?
:

 

[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

 

[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)

 

[Biff]

Hi!

Try this:

A1 = 46
B1 = 44:00:00

C1 = =A1/(B1*24)

Format as GENERAL

Biff