How do I calculate man-hours with Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sfjaye - 13 Jun 2005 18:50 GMT

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.

sfjaye@hotmail.com

Thank you.

Signature

SanFrancisco J (sfjaye)

Reply to this Message

Gord Dibben - 13 Jun 2005 20:59 GMT

In B1 enter =A1 * 8

Drag/copy down column B.

Gord Dibben Excel MVP

>I'm a novice with Excel.
>
[quoted text clipped - 7 lines]
>
>Thank you.

Reply to this Message