Want report on average duration to show in hours

[Goran WitchDoc]

I wonder if it is possible to make the vertical line here in hours instead of "days". I have put the attribute "max_unit=hours" on the field so when looking on an incident the task sla show the duration in hours, like 34 hours.

But then I put a report on the vaules, I still get that in "days"...

Like this:

I rather have it in ours like: 27hours, 56hours etc...

Hoping that there are a settting or something simular so I don't have to make a own field and the the vaule there in hours and then do the average on that field.

[abilash_017]

Hi Goran,

It is a default thing in Servicenow so you cannot get that in hours. You can do one thing to get it in hours-   create an OOB(out of box) field and write a business rule to copy the data from that particular field and hide it on the form. but still you can see OOB field in reporting and your issue will be solved.

Thank you

[Goran WitchDoc]

Well, that's sad, that was what I wrote and was hoping not to do. But I don't want the OOB field in the reporting.... I would need to use my own field in the report.

[Harry Campbell2]

Hi Goran, did you ever resolve this? I am having the exact same issue.

Many Thanks

Harry

[Goran WitchDoc · Accepted solution]

Yea,

Not with the oob things. I hade to create a own field that I called Business elapsed in hours.

I then in the calculated value put the code to recount the time into hours.

It looks like this:

Then I use that field instead in the report and get something like this:

Hope this will help you. Let me know if you got any other questions or ideas.

//Göran