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.

One way:

=4*1.5/1023 === 0.005865103 mh/case


In article ,
bkk wrote:

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.

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bkk" wrote:
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.

what function should i use, I did what you said and the function just stayed
their.

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bkk" wrote:
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.

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


On Sat, 10 Mar 2007 15:30:00 -0800, bkk wrote:

what function should i use, I did what you said and the function just stayed
their.

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bkk" wrote:
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.

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.


"Gord Dibben" wrote:

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


On Sat, 10 Mar 2007 15:30:00 -0800, bkk wrote:

what function should i use, I did what you said and the function just stayed
their.

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bkk" wrote:
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.

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.
--
David Biddulph

"bkk" wrote in message
...
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.


"Gord Dibben" wrote:

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


On Sat, 10 Mar 2007 15:30:00 -0800, bkk
wrote:

what function should i use, I did what you said and the function just
stayed
their.

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bkk" wrote:
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.