formula to average how many units per minute

[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

 

[Mike H]

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

 

[Jarek Kujawa]

assuming yr expected result should be 2.4, try:

=A1/(1440*D1)