Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for showing items per minute PoppaButch Excel Worksheet Functions 1 June 11th 08 10:15 PM
How do I set cells to sum/average/etc time? e.g. 1 minute 30 secs TavernerResearch Excel Worksheet Functions 2 April 6th 06 02:16 AM
minute formula tryingtolearn Excel Discussion (Misc queries) 1 January 12th 06 02:23 PM
Using time formats in minute units josh Excel Discussion (Misc queries) 4 September 11th 05 10:19 PM
Formula for Hour Minute and Second Dr.H.Subramanian Excel Worksheet Functions 7 August 10th 05 12:34 PM


All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"