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) |
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. |
All times are GMT +1. The time now is 04:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com