Can Duration (sum of time worked) be displayed in just hours and minutes in a report?

YenGar
Mega Sage

‎08-31-2020 12:24 PM

Hi all, 

I have some reports that calculate the time worked and display it in a single score (sum of the time worked for all tasks). The widget is displaying the sum in days, hours and minutes. I have a requirement to have those widgets show the sum in just hours and minutes. So instead of 1 Day 2 hours 30 Minutes, it would need to be displayed as 26 Hours 30 Minutes. Is this possible to do in the report? Below is a screen shot of the current reports. 

find_real_file.png

Thank you!

Yen

Preview file
39 KB
0 Helpfuls
  • 1,671 Views
2 REPLIES 2

Onkar Pandav
Tera Guru

‎08-31-2020 12:41 PM

Hi,

Below thread might be helpful on this. Please check.

https://community.servicenow.com/community?id=community_question&sys_id=03cfb2addb58dbc01dcaf3231f96...

 

0 Helpfuls

YenGar
Mega Sage
In response to Onkar Pandav

‎09-01-2020 09:36 AM

Thank you Onkar! I did what Gorlan suggested in the thread. It worked as expected to show the time in a decimal view but unfortunately this is not what the stakeholder had in mind. They want to see the widget show the time in the same format as duration but not have 24 hours automatically be represented as 1 day. They want to see it as HH MM. I don't think there's going to be a clean way to show this though. Thank you for the suggestion either way!

Yeny

0 Helpfuls