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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Thank you!
Yen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-31-2020 12:41 PM
Hi,
Below thread might be helpful on this. Please check.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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