How can I display resolve time in hours and minutes?

Allison3
Kilo Guru

I have created a dashboard that has the KPI - Average incident resolution time by assignment group. On the KPI it displays in house and minutes. But when you drill into it and look at the records it is showing it in seconds. How can I get the list view to show the resolve time in hours and minutes?

find_real_file.png

 

find_real_file.png

1 ACCEPTED SOLUTION

Vignesh21
Kilo Guru

Hi Allison,

 

Check this link it helps you translate the seconds to days and minuites.

https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/administer/time/task/t_DisplayRes...

 

 

Regards,

Vignesh

View solution in original post

5 REPLIES 5

Vignesh21
Kilo Guru

Hi Allison,

 

Check this link it helps you translate the seconds to days and minuites.

https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/administer/time/task/t_DisplayRes...

 

 

Regards,

Vignesh

Thank you! I knew it was an easy fix I just couldn't find where it was

Nitin_NOW
Tera Guru

You can write a before BR and can put the below piece of line into the script field. 

current.u_resolved=gs.nowDateTime(); //replace u_resolved with your field value.

Please hit correct based in impact of response.

Regards!

durga21
Tera Contributor

thanks that was really helpfull