B
bkk
how would i get the man hours to do a load. I have 4 workers and it took
them 1:30 to load 1023 cases.
them 1:30 to load 1023 cases.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
=4*1.5/1023 ===> 0.005865103 mh/case
=4*1.5/1023 ===> 0.005865103 mh/case
M
Max
Assuming
#workers in A2: 4,
time taken in B2: 1:30 (time format),
total cases in C2: 1023,
Place
In D2: =A2*(B2*24)
In E2: =D2/C2
Format D2 and E2 as number to taste
D2 returns the total manhours (= #workers x time taken*)
*with the time in B2 converted to decimal time via the "x 24" bit
E2 returns the required manhours per case (= total manhours / total cases)
You could select D2:E2 and simply copy down to return corresponding results
for other sets of inputs in A3:C3. A4:C4, etc
#workers in A2: 4,
time taken in B2: 1:30 (time format),
total cases in C2: 1023,
Place
In D2: =A2*(B2*24)
In E2: =D2/C2
Format D2 and E2 as number to taste
D2 returns the total manhours (= #workers x time taken*)
*with the time in B2 converted to decimal time via the "x 24" bit
E2 returns the required manhours per case (= total manhours / total cases)
You could select D2:E2 and simply copy down to return corresponding results
for other sets of inputs in A3:C3. A4:C4, etc
B
bkk
what function should i use, I did what you said and the function just stayed
their.
their.
G
Gord Dibben
If you type or copied Max's formulas to D2 and E2 and it remains a formula in
the cell, could be your cell was formatted as text.
Re-format the cell to General then hit F2 and ENTER.
Gord Dibben MS Excel MVP
the cell, could be your cell was formatted as text.
Re-format the cell to General then hit F2 and ENTER.
Gord Dibben MS Excel MVP
B
bkk
I changed the format and that worked but my man hours per case wasn't but
0.01 and I don't think that could be right. I have 4 workers it took 9:00
hours to load 5700 cases.
0.01 and I don't think that could be right. I have 4 workers it took 9:00
hours to load 5700 cases.
D
David Biddulph
OK, what answer do *you* think Excel's arithmetic should give when it is
dividing 36 man hours by 5700?
0.006316 if you want a few more decimal places, or about 23 seconds per
case.
dividing 36 man hours by 5700?
0.006316 if you want a few more decimal places, or about 23 seconds per
case.