Effort spent on a incident

pavankum
Kilo Expert

I am adding a field called Effort spent on the from and i have to update manually how much time i have spent on the incident before assigning it to some one else.
here the same process continues until the incident resolved. what i need to do it to show cumulative total.
for example: if assigned 1 works for 2 hrs and update the incident before assigning it to other person and assigned 2 will work and update the field with 3 hours after update it should show 5 hrs.

6 REPLIES 6

PeterWiles
Kilo Sage

There is a field called "Time Worked" which does this for you. Just add it to the form.
You can then view the "incident_time_worked" or "task_time_worked" table to view all updates. This will track how much time each person has worked on each task.

You can then pull a report off summing the times.

I use this for my teams.


We tried the way as you said, but our internal customers really wants to do it manually...they will simultaneously work on some other incidents so they will put only either 1 or 2 hours as time worked even if the incident opened two days ago..
And one more thing is they will not log into the tool while working they will check their mails and starts working.. finally when they want to make the incident state to resolved then only they will use the tool. So the Time_worked field is not suitable in my organization.


You can manually amend the timer.

Anyway, you will need to create something similar with a new table to store the effort value for each user/update. Then run the report from that table using the sum field to add it up.


You can also pause the time worked field by default using a script...

http://www.servicenowguru.com/scripting/client-scripts-scripting/pausetoggle-time-worked-field/

The time worked field actually adds entries in the 'task_time_worked' table as it is updated I think. I agree with Peter that you should use the time worked field.