This is a migrated thread and some comments may be shown as answers.

Time conversion problem during the export into excel

1 Answer 27 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Dharmesh
Top achievements
Rank 1
Dharmesh asked on 31 Jul 2010, 10:51 AM
hi,

why total time 36:12:30 is converted into 1.12:12:30 while doing the export into excel?
i want the original time that is : 36:12:30. what will be the solution?

Dharmesh

1 Answer, 1 is accepted

Sort by
0
Tsvetina
Telerik team
answered on 05 Aug 2010, 09:06 AM
Hello Dharmesh,

Could you please elaborate a little more on how you set up your export? How do you format the cells that export the time value? Are you using the mso-number-format style attribute? Could you please share the code where you configure your Excel export?

Generally speaking, I assume there is some problem with the cell formatting. You can browse this help article in order to get guidelines on how to properly prepare your data for export.

Regards,
Tsvetina
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Grid
Asked by
Dharmesh
Top achievements
Rank 1
Answers by
Tsvetina
Telerik team
Share this question
or