A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Man hours calculation



 
 
Thread Tools Display Modes
  #1  
Old October 1st, 2008, 11:18 AM posted to microsoft.public.excel.worksheet.functions
Mama Mia
external usenet poster
 
Posts: 7
Default Man hours calculation

How do I calculate man hours for a month?
  #2  
Old October 1st, 2008, 11:33 AM posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
 
Posts: 8,419
Default Man hours calculation

Not enough information, we need to see some sample data

Mike

"Mama Mia" wrote:

How do I calculate man hours for a month?

  #3  
Old October 1st, 2008, 12:26 PM posted to microsoft.public.excel.worksheet.functions
Niek Otten
external usenet poster
 
Posts: 2,533
Default Man hours calculation

=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:
ToolsAdd-ins, check Analysis Toolpak.


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


  #4  
Old October 1st, 2008, 12:27 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default Man hours calculation

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?



  #5  
Old October 1st, 2008, 03:26 PM posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire
external usenet poster
 
Posts: 2,232
Default 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 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?

  #6  
Old October 1st, 2008, 04:53 PM posted to microsoft.public.excel.worksheet.functions
Rick Rothstein[_2_]
external usenet poster
 
Posts: 2,013
Default Man hours calculation

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?


  #7  
Old April 20th, 2010, 07:56 AM posted to microsoft.public.excel.worksheet.functions
raj rajesh
external usenet poster
 
Posts: 1
Default 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?

Previous Posts In This Thread:

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:

Man hours calculation
Not enough information, we need to see some sample data

Mike

"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)*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:
ToolsAdd-ins, check Analysis Toolpak.


"Mama Mia" wrote in message news
On Wednesday, October 01, 2008 7:27 AM
David Biddulph wrote:

Man hours calculation
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

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

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

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 wonderful
resource...

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

--
Rick (MVP - Excel)

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

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.

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
http://www.eggheadcafe.com/tutorials...nimate-wp.aspx
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.