XLS TimeSpan format issue

2 posts, 0 answers
  1. Davor
    Davor avatar
    1 posts
    Member since:
    Feb 2018

    Posted 14 Feb 2018 Link to this post

    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?

  2. Nasko
    Admin
    Nasko avatar
    1070 posts

    Posted 19 Feb 2018 Link to this post

    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
Back to Top