- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-10-2025 06:11 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2025 11:19 AM
Hi,
You can achieve it by creating 'glide.export.excel.duration.readable_string' property (if not already exist) and set it to true.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-10-2025 06:49 AM
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2025 11:19 AM
Hi,
You can achieve it by creating 'glide.export.excel.duration.readable_string' property (if not already exist) and set it to true.