내 커뮤니티 업적 표시줄을 확대합니다.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
해결됨

How might one remove posted task travel time from budgeted hours

Avatar

Level 1

Hello,

 

We have people post their travel time on projects to a task on their task list. We don't bill our clients for travel time. I have a custom form that lists total budget hours, then a field that subtracts the actual hours posted to the project to show their remaining budget on their dashboard, but I cannot figure out how to pull out or separate/remove the hours posted to a task where the "source" is Travel Time.

 

Task List Hour Type = Task Time

Source = Travel Time

 

Just need a way to have a field that takes Actual Hours Posted to the project minus any Travel Time Hours posted so that I can show actual budget hours remaining. 

Hoping someone can help? ...and unfortunately no, I don't have fusion.

 

Thank you!

주제

토픽은 커뮤니티 콘텐츠를 분류하여 관련성 있는 콘텐츠를 찾는 데 도움이 됩니다.

1 채택된 해결책 개

Avatar

정확한 답변 작성자:
Community Advisor

I'm not aware of a way to achieve this: 
As far as the project is concerned, a booked hour is a cost to the project and therefore part of the hours collection. 

 

By using a "Travel time" hour type you exclude it from the revenue/cost calculations by unchecking Count as Revenue (your current approach would still include them because the hours are Task time).

 

Workfront only has a field that captures total hours booked on the project, it doesn't split by hour type.

 

Best I can do is a grouped HOUR report (here based on hour type, but you could also group by checking source.name=Travel)

SveniX_1-1746802641037.png

 

원본 게시물의 솔루션 보기

3 답변 개

Avatar

정확한 답변 작성자:
Community Advisor

I'm not aware of a way to achieve this: 
As far as the project is concerned, a booked hour is a cost to the project and therefore part of the hours collection. 

 

By using a "Travel time" hour type you exclude it from the revenue/cost calculations by unchecking Count as Revenue (your current approach would still include them because the hours are Task time).

 

Workfront only has a field that captures total hours booked on the project, it doesn't split by hour type.

 

Best I can do is a grouped HOUR report (here based on hour type, but you could also group by checking source.name=Travel)

SveniX_1-1746802641037.png

 

Avatar

Community Advisor

I'm not clear on where you are stashing this "travel time" task, but as long as it is not in the same project, you might want to look into filtering hour types and see if it would work for you. See this link:

https://experienceleague.adobe.com/en/docs/workfront/using/manage-work/projects/manage-projects/edit...

 

I wasn't able to get this working, myself, but that's OK, we don't need to do this yet. 

Avatar

Administrator

@janellebr1 Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!



Kautuk Sahni