what formula to use to calculate piece / time

  • Thread starter Thread starter RompStar
  • Start date Start date
R

RompStar

Ok, I have a column in excel that tells me the piece count that people
do, they have a start time column and end time column and the time that
it took to do that is figured out by:

=TEXT(J4-I4,"h:mm")

in column K..

the count piece is in column H.

How do I divide the count, say is column H reads 1500, and total time
it took to do that was 2:00 2 hours, how do you divide

1500 by that time value ? or am I thinking it right ?
 
You have to multiply the time by 24 to get hours as a decimal
number of hours -- time is a fraction of a day (24 hours = 1 day)..
Time started I4: 14:00
Time finished J4: 16:00
piece count H4: 1500
pieces per hr K4: = H4 / (24 * (j4 - i4))

format K4 as desired comma with 1 decimal
you can do this with tool bar buttons, with
with format, cells, number, or with custom format
i.e. _(* #,##0.0_);_(* (#,##0.0);_(* "-"??_);_(@_)
 
Back
Top