View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default formula to average how many units per minute

Hi,

Assuming your data are in A2 to D2 and for this example you expect 144, try
this

=60/(D2*1440)*A2

Format as general

Mike

"dfarr" wrote:

I'm an trying to enter a formula so i can determine how many production units
are completed per minute.
for example:


# of Courses Start Finish Min to Comp

12 5:37 5:42 0:05