While export to excel, how to convert seconds to hh:mm:ss


I am using datatype as “time” for showing in hh:mm:ss format, but while exporting to excel, this feature is not working and it shows timing in seconds only.
Any solution for this, thanks.

1 answer

WebDataRocks Team WebDataRocks October 19, 2020

Hello, Raj,
Thank you for posting to our forum.
Our team wants to inform you that we did not manage to reproduce the issue with the "time" data type while exporting to Excel. We tested both on JSON and CSV data sources and specified the time field as row, column, and measure – timing in the exported file is shown in the hh:mm:ss format.
Could you please provide us with the code snippet or modify this example in a way the issue is reproducible? This would greatly help us in our further investigation.
Looking forward to your response.
Best regards,
WebDataRocks Team