Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 1st 08, 11:18 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 1
Default Man hours calculation

How do I calculate man hours for a month?

  #2   Report Post  
Old October 1st 08, 11:33 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
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   Report Post  
Old October 1st 08, 12:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
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   Report Post  
Old October 1st 08, 12:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
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   Report Post  
Old October 1st 08, 03:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
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   Report Post  
Old October 1st 08, 04:53 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 5,934
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   Report Post  
Old April 20th 10, 07:56 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2010
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
  #8   Report Post  
Old September 16th 17, 11:26 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2017
Posts: 1
Default Man hours calculation

On Wednesday, 1 October 2008 15:48:01 UTC+5:30, Mama Mia wrote:
How do I calculate man hours for a month?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time calculation of 8:00 am - 4:30 pm at 8.5 hours How??? KC1952 Excel Discussion (Misc queries) 3 December 24th 07 05:23 PM
Work hours calculation albertmb Excel Discussion (Misc queries) 3 February 28th 07 07:40 PM
Schedule hours calculation RJ Swain Excel Discussion (Misc queries) 6 November 21st 06 09:32 PM
HOURS CALCULATION Stuart Carnachan Excel Discussion (Misc queries) 2 October 31st 06 04:26 PM
Calculation of full hours [email protected] Excel Worksheet Functions 1 September 8th 05 06:26 PM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017