How to calculate time effort spent on ticket in Service Now

n_16
Tera Contributor

Hello Community,

 

How to calculate time effort spent on ticket in Service Now.

 

Thanks in advance

4 REPLIES 4

Saiganeshraja
Kilo Sage
Kilo Sage

There is a field on incident form called as time worked , levarage that field.

I tried this solution. But, this col. is showing blank. Pls help

Time worked only works if you have the field on the form. While the user is on the record it will automatically track the time. However if they leave the incident without doing a save either by click save or update it will not save the time spent. Another thing to note that if someone goes into and incident the post a comment or work note that is not a save. The final thing to note is time worked is saved to another table as there could be multiple entries for incident. The table name is task_time_worked and you can add this as a related list on the incident.

 

Edit: An additional not is that task time worked can be added to any task type that is extended from the task table. Which are most things in ITSM (incident, request, request item, catalog task, change, change task, etc.)

Juhi Poddar
Kilo Patron

Hello @Minal01 

Rightly said by @Brian Lancaster , in addition to this I would like to add few points

  • Timer in time_worked can be paused and start at any point with the help of play button JuhiPoddar_0-1731523116758.png
  • This field also shows the present session time as well as the total time on form. In the screenshot '14' is the current session time whereas '19' is the total time.
  • Once the form saves/loads, present session time starts from 0.
  • Every time the record is saved a new record is created in 'task_time_worked' table with total time worked for that particular session.
  • Time worked in related list looks something like thisJuhiPoddar_1-1731523564398.png

"If you found my answer helpful, please give it a like and mark it as the "accepted solution". It helps others find the solution more easily and supports the community!"

 

Thank You
Juhi Poddar