Resource management
I am trying to create a resource management sheet to show who of my resources is busy or not and what his utilization % is. My resources travel to locations and i would like to be able to see in resource view the time that is being used for travel separately from the class time.
Appreciate your help,
Aldina
Comments
-
Hi Aldina, have you thought about using a seperate sheet just for travelling time. The time spend travelling and class time would then be shown seperately in the Resource View.
Mick
-
Thanks @Mick Jordan
I guess.. but that means having to build a new sheet from scratch... or is there a formula that I can do something like ..if the location is not .YXZ..then duration (whatever on the duration column)+6hours? (Not an excel expert tho..)
- still, the resource view uses start and end time not duration..i think.
Any thoughts?
Thanks Mick.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives