# Man hours calculation

Discussion in 'Microsoft Excel Worksheet Functions' started by Mama Mia, Oct 1, 2008.

1. ### Mama MiaGuest

How do I calculate man hours for a month?

Mama Mia, Oct 1, 2008

2. ### Mike HGuest

Not enough information, we need to see some sample data

Mike

"Mama Mia" wrote:

> How do I calculate man hours for a month?

Mike H, Oct 1, 2008

3. ### Niek OttenGuest

=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:

"Mama Mia" <> wrote in message news...
| How do I calculate man hours for a month?

Niek Otten, Oct 1, 2008
4. ### David BiddulphGuest

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).
--
David Biddulph

"Mama Mia" <> wrote in message
news...
> How do I calculate man hours for a month?

David Biddulph, Oct 1, 2008
5. ### ShaneDevenshireGuest

Hi,

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.

--
Thanks,
Shane Devenshire

"Mama Mia" wrote:

> How do I calculate man hours for a month?

ShaneDevenshire, Oct 1, 2008
6. ### Rick RothsteinGuest

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

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

--
Rick (MVP - Excel)

"Mama Mia" <> wrote in message
news...
> How do I calculate man hours for a month?

Rick Rothstein, Oct 1, 2008
7. ### raj rajeshGuest

For safety

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?

On Wednesday, October 01, 2008 6:18 AM
MamaMi wrote:

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

On Wednesday, October 01, 2008 6:33 AM
Mike wrote:

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

Mik

"Mama Mia" wrote:

On Wednesday, October 01, 2008 7:26 AM
Niek Otten wrote:

=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

"Mama Mia" <> wrote in message news...

On Wednesday, October 01, 2008 7:27 AM
David Biddulph wrote:

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

On Wednesday, October 01, 2008 10:26 AM
ShaneDevenshir wrote:

RE: Man hours calculation
Hi

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

"Mama Mia" wrote:

On Wednesday, October 01, 2008 11:53 AM
Rick Rothstein wrote:

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)

On Sunday, May 24, 2009 12:52 AM
lokesh kumar wrote:

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.

On Tuesday, July 07, 2009 10:48 AM
MHAHMED wrote:

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.

On Friday, August 28, 2009 11:18 AM
nazia wrote:

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.

On Friday, August 28, 2009 11:19 AM
nazia wrote:

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

raj rajesh, Apr 20, 2010
8. ### Marlon

Joined:
Jun 15, 2010
0
I have 541man hours remaining. How many carpenters will I need and what will be the duration. Could you give me the formula?

Marlon, Jun 15, 2010
9. ### Marlon

Joined:
Jun 15, 2010
0
5000 total man hours

What's the man power needed?

What will the duration be?

Marlon, Jun 15, 2010

Joined:
Jun 15, 2010