formula to average how many units per minute

  • Thread starter Thread starter dfarr
  • Start date Start date
D

dfarr

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
 
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
 
Back
Top