Exported report is showing duration filed values in seconds

ashokbodaga
Tera Contributor

Hi ,

 

I created a report on  database view with duration fields are displayed in reports as 05 days 11 hours as an example but once exported to an excel sheet, they get displayed as integers representing the number of seconds instead of 05 days 11 hours.

 

Could you please suggest a way to export duration like days and hours other than seconds.

 

 

Thank you.

 

 

 

1 ACCEPTED SOLUTION

Syed14
Mega Guru

Hi,

You can achieve it by creating 'glide.export.excel.duration.readable_string' property (if not already exist) and set it to true.

Syed14_0-1751307472877.png

 

View solution in original post

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @ashokbodaga ,

 

This is default behavior. Please change accordingly in the Excel sheet or where ever you're exporting to.

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Syed14
Mega Guru

Hi,

You can achieve it by creating 'glide.export.excel.duration.readable_string' property (if not already exist) and set it to true.

Syed14_0-1751307472877.png