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
|