Hi,
When exporting the data to Excel, the duration field is currently displaying in seconds. However, I would like it to show in hours and minutes only.
Could you please advise how to achieve this?
Thank you in advance for your support.
that's the out of the box behavior
the field is duration type so they will always give value in milliseconds
Couple of ways
1) Workaround is to use PDF rather than Excel or CSV
OR
2) create a custom field which holds string value of that duration and use that in reporting
After export as Excel time fields are showing seconds but i want to see it in only Hours and Minutes
OR
3) try to see if you can use function field in report and convert the milliseconds to hours
OR
4) inform user to apply Formula in Excel and convert that, response from Jeff
How to display duration field value in a proper format in an excel report
If my response helped please mark it correct and close the thread so that it benefits future readers.
that's the out of the box behavior
the field is duration type so they will always give value in milliseconds
Couple of ways
1) Workaround is to use PDF rather than Excel or CSV
OR
2) create a custom field which holds string value of that duration and use that in reporting
After export as Excel time fields are showing seconds but i want to see it in only Hours and Minutes
OR
3) try to see if you can use function field in report and convert the milliseconds to hours
OR
4) inform user to apply Formula in Excel and convert that, response from Jeff
How to display duration field value in a proper format in an excel report
If my response helped please mark it correct and close the thread so that it benefits future readers.
