formula to average how many units per minute
 

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

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

formula to average how many units per minute
 

assuming yr expected result should be 2.4, try:

=A1/(1440*D1)

On 13 Sty, 21:00, 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