Units Produced / (finish time minus start time)=Units Per Hr

G

Gary A

I am having difficulty with converting a finish time minus start time in a
time format into something I can divided the Units Per Hr number to determine
productivity
 
P

Pete_UK

Try something like this:

= Units_produced / ((finish_time - start_time) * 24)

substitute your cell references as necessary.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top