Man hours calculation

  • Thread starter Thread starter Mama Mia
  • Start date Start date
=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?
 
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).
 
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.
 
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
 
I have 541man hours remaining. How many carpenters will I need and what will be the duration. Could you give me the formula?
 
Mike H said:
Not enough information, we need to see some sample data

Mike

"Mama Mia" wrote:

> How do I calculate man hours for a month?
Click to expand...

5000 total man hours

What's the man power needed?

What will the duration be?
 
Back
Top