Home

MS Project timesheet hours

%3CLINGO-SUB%20id%3D%22lingo-sub-393739%22%20slang%3D%22en-US%22%3EMS%20Project%20timesheet%20hours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393739%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20organization%20we%20have%20people%20putting%20time%20in%20their%20timesheets%20to%20match%20the%20projects%20they%20worked%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20data%20is%20then%20pulled%20in%20a%20timesheet%20report%2C%20where%20the%20hours%20come%20from%20their%20timesheets%20to%20see%20what%20they%20do%20every%20week.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20one%20issue%20I%20am%20getting%2C%20is%20that%20if%20someone%20acts%20as%20a%20delegate%20and%20puts%20hours%20in%20someone%20else's%20timesheet%2C%20the%20hours%20will%20appear%20under%20his%20name%20in%20the%20timesheet%20report.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20work%20around%20for%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-481986%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Project%20timesheet%20hours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481986%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F313319%22%20target%3D%22_blank%22%3E%40aghazaly%3C%2FA%3Enot%20sure%20what%20your%20queries%20are%20since%20you%20didn't%20share%2C%20but%20here's%20how%20I'm%20doing%20it.%20Query%20the%20AssignmentTimePhasedDataSet%2C%20Projects%2C%20and%20Resources%20table.%20Assignments%20contains%20%22actual%20work%22%20(which%20come%20from%20time%20submitted%20via%20timesheets%20%5Bwe%20have%20%22protected%20actuals%22%20enabled%22%5D).%20Link%20to%20information%20about%20the%20person%20from%20the%20resources%20table%20(like%20name%2C%20team%2C%20etc)%20by%20joining%20on%20Resource%20ID.%20Add%20in%20information%20about%20the%20assignment%20(like%20project%20name)%20by%20joining%20on%20the%20ProjectID.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20partial%20example%2C%20here's%20the%20odata%20query%20I%20use%20against%20the%20assignments%3A%3C%2FP%3E%3CBLOCKQUOTE%3E%3CP%3E%3CEM%3E%3DOData.Feed(%22%3CA%20href%3D%22https%3A%2F%2Fyoursitehere.sharepoint.com%2Fsites%2Fpwa%2F_api%2FProjectData%2FAssignmentTimephasedDataSet%3F%24select%3DProjectId%2CTimeByDay%2CAssignmentWork%2CResourceId%26amp%3B%24filter%3DAssignmentWork%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoursitehere.sharepoint.com%2Fsites%2Fpwa%2F_api%2FProjectData%2FAssignmentTimephasedDataSet%3F%24select%3DProjectId%2CTimeByDay%2CAssignmentWork%2CResourceId%26amp%3B%24filter%3DAssignmentWork%3C%2FA%3E%20ne%200%20and%20TaskIsActive%20eq%20true%22%2Cnull%2C%5BImplementation%3D%222.0%22%5D)%3C%2FEM%3E%3C%2FP%3E%3C%2FBLOCKQUOTE%3E%3C%2FLINGO-BODY%3E
aghazaly
Occasional Visitor

In my organization we have people putting time in their timesheets to match the projects they worked on.

 

This data is then pulled in a timesheet report, where the hours come from their timesheets to see what they do every week.

 

However one issue I am getting, is that if someone acts as a delegate and puts hours in someone else's timesheet, the hours will appear under his name in the timesheet report.

 

Is there a work around for this issue?

 

 

1 Reply

@aghazalynot sure what your queries are since you didn't share, but here's how I'm doing it. Query the AssignmentTimePhasedDataSet, Projects, and Resources table. Assignments contains "actual work" (which come from time submitted via timesheets [we have "protected actuals" enabled"]). Link to information about the person from the resources table (like name, team, etc) by joining on Resource ID. Add in information about the assignment (like project name) by joining on the ProjectID.

 

As a partial example, here's the odata query I use against the assignments:

=OData.Feed("https://yoursitehere.sharepoint.com/sites/pwa/_api/ProjectData/AssignmentTimephasedDataSet?$select=P... ne 0 and TaskIsActive eq true",null,[Implementation="2.0"])