functions to use
 

I have a worksheet created and need a little help with how to find man hours
per case load onto the truck. Have total cases per night and start and stop
time of workers.

functions to use
 

Stop minus Start divided by cases?
Make sure your formula's cell is formatted as [h]:mm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"bkk" wrote in message
...
I have a worksheet created and need a little help with how to find man
hours
per case load onto the truck. Have total cases per night and start and
stop
time of workers.

functions to use
 

You posted a very similar question in a different thread. PLEASE don't
post multiple questions for the same problem - it just tends to fragment
your answers.

One way:

A1: <start time
B1: <end time
C1: =MOD(B1-A1,1)*24 <==== # of hours between A1 & B1
D1: <cases
E1: <number of workers
F1: =(C1*E1)/D1



In article ,
bkk wrote:

I have a worksheet created and need a little help with how to find man hours
per case load onto the truck. Have total cases per night and start and stop
time of workers.