Calculating total number of working hours per year

# Calculating total number of working hours per year

• Wednesday, February 22, 2012 7:46 AM

Dear colleagues,

I need to calculate man-years for each resource of my project. As far as I understand, I need to divide Work of a Resource to the total number of working hours per year of that Resource (with respect to it's Calendar).

If this makes sence, could you advice me an easy way to calculate total number of working hours per year using corresponding Calendar please?

• Edited by Wednesday, February 22, 2012 7:46 AM
•

### All Replies

• Wednesday, February 22, 2012 8:19 AM

>> divide Work of a Resource to the total number of working hours per year of that Resource (with respect to it's Calendar).

IMO, Work / Work Availability will give Percent Allocation for a resource.

I believe the following view/report will provide the values (man-years) that you need:

- Resource Usage view with Timescale tier in Years (hide task assignments in the table for easy viewing).

- Resource Work Summary report with Years as level of usage data.

Regards.
• Wednesday, February 22, 2012 5:32 PM

Andrey,

At my last consulting gig, we calculated this in the resource sheet using a custom number field with the following formula:

[Work]/60/####

Where ####= Total available hours in a year.

This formula allows you to tweak productivity with messing with the Max Units field.

Hope this helps.

Gregg D. Richie, PMP, MCTS; Author, Microsoft Project 2010, Microsoft Official Academic Course Series

• Wednesday, February 22, 2012 5:52 PM
Moderator

Hi,

set first day of year as start, then last day of year as finish

Assign the resource to that task

Insert the Work column.

Greetings,

• Wednesday, February 22, 2012 5:55 PM

A rather simplistic way is to put a year long task starting 2/1/12 and finishing 31/12 (fixed units) and apply your resource to it.  If you display the work as hours (tools / options / schedule) this will allow the hours for 1 year using the resource calandar to be displayed in the work column.

If you understandably don't want to polute the actual schedule with this year long task you can export the calandar(s) into a fresh plan (Tools / customise and copy the calendars from your actual plan to a blank one) and perform the trick.

Note that you can display the work on an individual task in man months by adjusting the "Work shown in" value in tools options which might get you close for any individual task.

Hope this helps

Miles

• Monday, February 27, 2012 10:53 AM

Andrey,

At my last consulting gig, we calculated this in the resource sheet using a custom number field with the following formula:

[Work]/60/####

Where ####= Total available hours in a year.

This formula allows you to tweak productivity with messing with the Max Units field.

Hope this helps.

Gregg D. Richie, PMP, MCTS; Author, Microsoft Project 2010, Microsoft Official Academic Course Series

OK. That's similar to I want to calculate: take a project, select a resource, calculate total hours spent by the resource and divide it on total number of working hours available for the resource with respect to it's Calendar.

How do I automatically calculate #### based on Calendar of a Resource?

• Monday, February 27, 2012 11:28 AM

>> How do I automatically calculate #### based on Calendar of a Resource?

In a resource table, insert ProjDateDiff("1-Jan-2012","31-Dec-2012",Name)/60 into a custom Number
field. I assume your project starts and finishes in 2012.
• Monday, February 27, 2012 11:35 AM
Moderator

Hello,

Good solution! Just a small precision fora first time formula user: Name must be beween square brackets

[Name]

Greetings,