| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I calculate man-hours with Excel?
I'm a novice with Excel.
I need a simple answer to a simple question. In column A of Excel, I have the number of employees on a given day. How can I make column B show a number that is eight times the number of column A? In other words, if column A is five, column B should automatically show 40. If column A is eleven, column B should be 88 and so on. Thank you. -- SanFrancisco J (sfjaye) |
|
#2
|
|||
|
|||
|
In B1 enter =A1 * 8
Drag/copy down column B. Gord Dibben Excel MVP On Mon, 13 Jun 2005 10:50:03 -0700, Sfjaye wrote: I'm a novice with Excel. I need a simple answer to a simple question. In column A of Excel, I have the number of employees on a given day. How can I make column B show a number that is eight times the number of column A? In other words, if column A is five, column B should automatically show 40. If column A is eleven, column B should be 88 and so on. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to calculate integrals with Excel? | Excel Worksheet Functions | |||
| How do I sum hours in Excel and convert to decimal numbers? | Excel Discussion (Misc queries) | |||
| How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions | |||
| CALCULATE HOURS WORKED | Excel Discussion (Misc queries) | |||
| How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions | |||
Linear Mode
