| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for showing items per minute
Hi,
I have been trying to come up with a formula where the end result would show how many items per minute. a1= 120 widgets (# is formated as number) b1 = 120 minutes(# is formated as [m]) conventional wisdom would tell you b1/a1 = 1 widget per minute I come up with 1440. What am i doing wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for showing items per minute
Excel times aren't stored as minutes, but as days.
60*24 = 1440. -- David Biddulph "PoppaButch" wrote in message ... Hi, I have been trying to come up with a formula where the end result would show how many items per minute. a1= 120 widgets (# is formated as number) b1 = 120 minutes(# is formated as [m]) conventional wisdom would tell you b1/a1 = 1 widget per minute I come up with 1440. What am i doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| minute formula | Excel Discussion (Misc queries) | |||
| Showing Mininum $ for items | Excel Worksheet Functions | |||
| Formula for Hour Minute and Second | Excel Worksheet Functions | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
| A formula to express distance per minute .... | Excel Discussion (Misc queries) | |||
Linear Mode
