Getting production times calculated

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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.
 
Bob said:
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.
Click to expand...


Well 9.94 is wrong as well - the correct answer (both by calculator and
Excel 2007) is 00.6.02
How are you doing this in Excel? (I can't reproduce anything that makes
238.6....)
 
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
 
Roger Govier said:
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
Click to expand...


Eh? Why so complicated?
Time in A1 (formatted hh.mm.ss), pieces in B1 (formatted in numbers), in C1
put A1/B1 (formatted in hh.mm.ss) gives 00.6.02 per piece.
 
Eh? Why so complicated?

Since the OP had expressed his results as General numbers, I kind of figured
he'd want to have his results in that format.
Of course, I may well have been wrong in making such an assumption.
 
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 said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top