Calculate Percentage of Days Worked

[KittyFace]

Hi all

I wonder if anyone can help me.
I am trying to pull together a resource tracker and calculate the percentage of days worked per week on a certain project. The problem I have is the working week is only 4.5 days (so this is the 100% capacity)

For example I have 2 projects and the resource has split their time 2.25 days on each project.
I am trying to show if they have capacity to take on more work or are working to the full 100%.

Hope I am explaining this well enough J

Any help would be amazing!

Many thanks


Kitty =^,,^=

 

[tomppity]

You mean something like this?

I can not post attachments, but if that is what you are looking for then you can download it from here:

http://s000.tinyupload.com/?file_id=12854222647313846810

 

[KittyFace]

Hi

Kind of Thanks for trying

I have taken a little screenshot of my sheet.

http://s000.tinyupload.com/?file_id=48942542582175080469

basically want to convert the sum total of days (in the % of time utilised) into a percentage using the 4.5 days as 100% of capacity.


Kitty =^,,^=

 

[tomppity]

Hi

Kind of Thanks for trying

I have taken a little screenshot of my sheet.

http://s000.tinyupload.com/?file_id=48942542582175080469

basically want to convert the sum total of days (in the % of time utilised) into a percentage using the 4.5 days as 100% of capacity.


Kitty =^,,^=

Okay, maybe like this then?