View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default 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