With 13 in B1 and 6:24 in C1

=B1/(C1*24)

format result as general or else it will display as time

I get 2.03125 not 2.166


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Ender-DI" wrote in message
...
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)