Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for showing items per minute | Excel Worksheet Functions | |||
How do I set cells to sum/average/etc time? e.g. 1 minute 30 secs | Excel Worksheet Functions | |||
minute formula | Excel Discussion (Misc queries) | |||
Using time formats in minute units | Excel Discussion (Misc queries) | |||
Formula for Hour Minute and Second | Excel Worksheet Functions |