| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions
need help with a worksheet and how to figure man hours per case.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
functions
One way:
Assume # of cases in A1, # of workers in B1, # of hours in C1, then: D1: =(B1*C1)/A1 In article , bkk wrote: need help with a worksheet and how to figure man hours per case. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
functions
Ok I have 4 workers and it took 10:25 hours to load 5,122 cases.
"JE McGimpsey" wrote: One way: Assume # of cases in A1, # of workers in B1, # of hours in C1, then: D1: =(B1*C1)/A1 In article , bkk wrote: need help with a worksheet and how to figure man hours per case. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
functions
OK,
A1: 4 B1: 10:25 C1: 5122 D1: =(B1*C1)/A1 formatted as time, D1 returns 00:00:29 man-hours per case. If you want to work in decimals rather than times, multiply B1 by 24 to get 10.4166667 hours. Then D1 (formatted as general, or some other Number format) returns 0.00813484 man-hours per case. In article , bkk wrote: Ok I have 4 workers and it took 10:25 hours to load 5,122 cases. "JE McGimpsey" wrote: One way: Assume # of cases in A1, # of workers in B1, # of hours in C1, then: D1: =(B1*C1)/A1 In article , bkk wrote: need help with a worksheet and how to figure man hours per case. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with functions | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
| Functions of x | Charts and Charting in Excel | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Linear Mode
