Time Sheet/Time Card reporting help

[Danielle10]

Good day! Would anyone be willing to help me figure out some time sheet/time card reports in ServiceNow? I do not understand the difference between creating reports using the Time Sheet table or the Time Card table? Time Sheets and Time Cards should both match right?

I need to figure out how to do these reports:

1. Total Project Hours across all projects

2. Total Project Hours per Month

Any help you can be! Thank you, kindly and enjoy!

[Manmohan K · Accepted solution]

Hi @Danielle10 ,

Here is a step by step process to create your reports

1. Total Project hours across all projects:

Data stage :

Type stage:

Choose type as bar

Configure stage:

Style stage:

Click on Run and you should get something like the below report

 2. Project hours per month

Data stage:

Type Stage:

Choose column chart in Time Series section

Configure Stage:

Style stage:

Also filter with state processed to only look at processed time cards

Run the report and it will look something like below

Please feel free to make changes and adjustments to the report according to your needs

Please mark answer as helpful and correct if it helped resolve the issue !!!

Regards,

Manmohan

[Manmohan K · Accepted solution]

Hi @Danielle10 ,

Here is a step by step process to create your reports

1. Total Project hours across all projects:

Data stage :

Type stage:

Choose type as bar

Configure stage:

Style stage:

Click on Run and you should get something like the below report

 2. Project hours per month

Data stage:

Type Stage:

Choose column chart in Time Series section

Configure Stage:

Style stage:

Also filter with state processed to only look at processed time cards

Run the report and it will look something like below

Please feel free to make changes and adjustments to the report according to your needs

Please mark answer as helpful and correct if it helped resolve the issue !!!

Regards,

Manmohan

[Danielle10]

Manmohan! You are such a blessing to me! Thank you so much for your help!

What is the difference between using the time sheet table or the time card table to create reports for hours worked by users?

Do you know how to create these 2 reports?

1. Invoicing – how many hours did this user work on all Projects from January to March?
2. How many billing hours for this project?
3. A report on allocated resources per project?

Thank you! I am thankful for your help.

[Manmohan K · Accepted solution]

Hi @Danielle10 ,

Please find details of the above requirements answered in the below link

https://www.servicenow.com/community/developer-forum/time-sheets-time-card-questions-and-report-help...

[rohitkathur]

Hi Manmohan, This is helpful, but i need two more splits, 1) Project wise, Currently upu are only considering that resources are working on one project only, what if i want to have a project specific view, Time card doesn't have the account name field 2) Ticket wise hours : say if multiple users worked on same ticket then how do we showcase that , mine main issue is project wise cut wherein i can filter by account and showcase the hours worked