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

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

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

Try something like this:

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

substitute your cell references as necessary.

Hope this helps.

Pete

On Feb 10, 1:27*am, Gary A <Gary
wrote:
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