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

XLS TimeSpan format issue

1 Answer 85 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Davor
Top achievements
Rank 1
Davor asked on 14 Feb 2018, 10:10 AM

I'm using: Telerik Reporting Q1 2015 v9.0.15.422

I have some data that is duration information (TimeSpan to be specific). I want to show duration in h:mm:ss  so that we can sum up durations in spreadsheet. However, I'm only able to show duration in hh:mm:ss format which can't be summed up in spreadsheet.  Is there any way to show TimeSpan in h:mm:ss format?

1 Answer, 1 is accepted

Sort by
0
Nasko
Telerik team
answered on 19 Feb 2018, 09:52 AM
Hello Davor,

We tested exporting a report to Excel and adding the durations together. Please find attached the used sample report and exported XLSX file with the durations sum.

Regards,
Nasko
Progress Telerik
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 Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Davor
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Share this question
or