Time format doesn't same when exporting excel from data grid

[Jaeyeon]

When I tried to export excel, the data format changed.

For example, the data that is seen in the browser looks like this: 01:01:30 

However, checking the excel after export, the time shows like this: 3690, which is seconds.

How can I get the same format in the browser and in excel?

Thanks.

{
			field: "cn_busy_grp",
			title: "통화시간",
			columns :[{
				field: "ts_busy_times",
				title: "총통화시간",
				template: '#=convertSecondsToString(ts_busy_times, "hms")#',
				footerTemplate: '#=convertSecondsToString(sum, "hms")#',
				groupFooterTemplate: '#=convertSecondsToString(sum, "hms")#',
				width: "80px"
			},

[Nikolay]

Hello Jaeyeon,

This is due to the fact that the Excel export engine uses the actual values which columns are bound to. However, this can be overcome with custom logic in the excelExport event handler. Please check out the following article showing this in a runnable example:

https://docs.telerik.com/kendo-ui/knowledge-base/column-template-export

Hope this helps.

Regards,

Nikolay
Progress Telerik