I believe Duke's formula is correct. However, it produces an answer of
2.03125 and not 48.75. Try the formula out and see what you get. You may
have to play with the formats of the cells. Ensure that the cell where the
answer goes is formatted as General or some sort of number format. Look
under Excel help for Time and you may learn more about how Excel calculates
with time and the issues you are having.

Hope this helps.

Bill Horton

"Ender-DI" wrote:

If only 13 total parts were produced, how is it supposed to read 48.75 parts
per hour?

It took 6 hours, 24 minutes to produce 13 parts. I need to show that that
breaks down to 2.166 parts per hour.


I think column C ought to be showing 48.75

You need to use the formula

=b1/(a1*24)