Roger,

That fixed my issue. Thanks. I am looking for Pcs/hour. I missed the fact
in the documentation the time needs to be multiplied by 24.

"Roger Govier" wrote:

Hi Bob

You have 2 errors (I believe).
If you want the Time taken per Piece, you should divide Time / Pieces.
You divided Pieces / Time and with a result cell formatted as General, that
gave you 238.6

However, Excel stores its times as fractions of a day, so we need to
multiply Time *24 to get to hours and then *60 to get to minutes.
So, with Time in A1, and Pieces in B1
=(A1*24*60)/B1 or =(A1*1440)/B1 formatted as General
gives the result of 6.0353 minutes per piece.

If, on the other hand you did want Pieces picked per Minute, then it would
be
=B1/(A1*1440)
which would give a result of 0.1657 pieces per minute
--
Regards
Roger Govier

"Bob" wrote in message
...
I have a total of 1346:16:00 hours formatted [h]:mm:ss. When I try to
divide
this into number of peices picked 13384. I get 238.60 but when I have
entered on the calculator I get 9.94. Can someone tell me what the proper
format is to return the proper result? Thanks.