Man hours calculation

[Mama Mia]

How do I calculate man hours for a month?

 

[Mike H]

Not enough information, we need to see some sample data

Mike

 

[Niek Otten]

=NETWORKDAYS(DATE(YEAR(A1),MONTH(A1),1),EOMONTH(A1,0),Holidays)*8

For 8 hours workdays. Holidays is a range with holiday dates. Look in HELP for NETWORKDAYS() for details. A1 contains a date in
the appropriate month. The day doesn't matter.
If you get a #NAME error:
Tools>Add-ins, check Analysis Toolpak.


| How do I calculate man hours for a month?

 

[David Biddulph]

If you have times in Excel time format hh:mm, add them up and multiply the
result by 24 to get an answer in decimal hours (formatted as general or
number, not as time).

 

[ShaneDevenshire]

Hi,

Here is another answer depending on what you are really asking:

If you have a column of times (entries of the form 7:00), say C2:C33 and you
want to get the total
=sum(c2:C33) and then formatting the cell to [h]:mm:ss format.

Or maybe you want to use =SUMIF(A2:A33,"Man Hours",C2:C33)
and to get Woman hours
=SUMIF(A2:A33,"Woman Hours",C2:C33)

You can see that you got 3 or 4 completely different answers, because you
question is not complete.

 

[Rick Rothstein]

When in doubt as to what something is, the internet is a wonderful
resource...

http://en.wikipedia.org/wiki/Man_hours

 

[raj rajesh]

man hours calculations as per indian standared.
for the month,year,deducts for the ltis, fatals.



MamaMi wrote:

Man hours calculation
01-Oct-08

How do I calculate man hours for a month?

Previous Posts In This Thread:

Man hours calculation
How do I calculate man hours for a month?

RE: Man hours calculation
Not enough information, we need to see some sample dat

Mik

:

=NETWORKDAYS(DATE(YEAR(A1),MONTH(A1),1),EOMONTH(A1,0),Holidays)*8For 8 hours
=NETWORKDAYS(DATE(YEAR(A1),MONTH(A1),1),EOMONTH(A1,0),Holidays)*

For 8 hours workdays. Holidays is a range with holiday dates. Look in HELP for NETWORKDAYS() for details. A1 contains a date in
the appropriate month. The day doesn't matter
If you get a #NAME error
Tools>Add-ins, check Analysis Toolpak


Re: Man hours calculation
If you have times in Excel time format hh:mm, add them up and multiply th
result by 24 to get an answer in decimal hours (formatted as general o
number, not as time)
-
David Biddulph

RE: Man hours calculation
Hi

Here is another answer depending on what you are really asking

If you have a column of times (entries of the form 7:00), say C2:C33 and you
want to get the tota
=sum(c2:C33) and then formatting the cell to [h]:mm:ss format

Or maybe you want to use =SUMIF(A2:A33,"Man Hours",C2:C33
and to get Woman hour
=SUMIF(A2:A33,"Woman Hours",C2:C33

You can see that you got 3 or 4 completely different answers, because you
question is not complete.

--
Thanks
Shane Devenshir

:

When in doubt as to what something is, the internet is a wonderful resource...
When in doubt as to what something is, the internet is a wonderfu
resource..

http://en.wikipedia.org/wiki/Man_hour

-
Rick (MVP - Excel)

answer
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

EQUIPMENT MAINTENANCE MAN HOURS CALCULATION PROCESS
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

EQUIPMENT MAINTENANCE MAN HOURS CALCULATION PROCESS
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

8r68iro908
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.


Submitted via EggHeadCafe - Software Developer Portal of Choice
A Framework to Animate WPF and Silverlight Pages Similar to the PowerPoint Slides
http://www.eggheadcafe.com/tutorial...0-c7354940d878/a-framework-to-animate-wp.aspx

 

[Marlon]

I have 541man hours remaining. How many carpenters will I need and what will be the duration. Could you give me the formula?

 

[Marlon]

Not enough information, we need to see some sample data

Mike

"Mama Mia" wrote:

> How do I calculate man hours for a month?

5000 total man hours

What's the man power needed?

What will the duration be?

 

[Marlon]

5000 total man hours

What's the man power needed?

What will the duration be?