Remember Me?

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

How do I calculate man hours for a month?

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

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

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

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:

"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,

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:

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
#8
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
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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post KC1952 Excel Discussion (Misc queries) 3 December 24th 07 06:23 PM albertmb Excel Discussion (Misc queries) 3 February 28th 07 08:40 PM RJ Swain Excel Discussion (Misc queries) 6 November 21st 06 10:32 PM Stuart Carnachan Excel Discussion (Misc queries) 2 October 31st 06 05:26 PM [email protected] Excel Worksheet Functions 1 September 8th 05 06:26 PM

All times are GMT +1. The time now is 10:30 PM.