Expand my Community achievements bar.

Pulling General Hours into a Project Report

Avatar

Level 2

Hey,

 

Looking for suggestions/definitive answer on how to tackle a report our client has requested. They would like to review planned vs actual hours spent on projects on a monthly basis, see the variance and also see how many hours in total a worker has logged split between project/task time vs general hours.

 

It will give them a steer on planning for upcoming months and also see how many hours are being logged on non project work. I have a project and an hours type report set up as I can't get what I need on the same report and started to wonder if it's possible. The project version is better in terms of only have one line for the project and I can get all the columns needed except for a total of all hours showing the split between task time and general time - is this even possible? I have tried to find an answer on community posts and can see some companies have a standalone project for non project work and users log at task level or others have created custom fields for each general hour type and the time is logged there rather than in the specific area on the timesheet.

 

Hoping there is some text mode or calculated which can achieve this.

 

Many thanks

2 Replies

Avatar

Community Advisor

vikki,

 

Not sure I follow what you're trying to accomplish.  This is a good link on how textmode for variance can be figured between planned and actual hrs, if needed.

Avatar

Level 2

Hi Kurt,

 

Many thanks for your reply and the link to the article/text mode. 

 

My main issue is being able to display the user's total hours broken down into Task/Project time vs General Time (e.g. Time Off/IT issues). I can't seem to bring in the general hours to a project report however the Hour report I also have set up can do this but doesn't condense all the hours in to each project so it's a lot of scrolling.