Excel Export Showing Duration Field in Seconds

[mhafizam]

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.

[Deepak Shaerma]

Hi @mhafizam 

Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning ‌‌
Thanks & Regards 
Deepak Sharma 

[Ankur Bawiskar · Accepted solution]

@mhafizam 

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.

[Ankur Bawiskar]

@mhafizam 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[mhafizam]

Hi,

Currently waiting for feedback from the customer. I’ve suggested using PDF instead of Excel or CSV, as I believe this should address the issue for now. Will provide further updates if additional assistance is needed.