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

  • Thread starter Thread starter Gary A
  • Start date Start date
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
 
Try something like this:

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

substitute your cell references as necessary.

Hope this helps.

Pete
 
Back
Top