View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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