ReportViewer problem with time format when exporting to Excel

0

I schedule with Asp. Net and C #.

I have several reports in which columns of a Tablix with information about times appear. My problem is that when exporting to Excel this report does not let me operate with these times.

If I have a Tablix column with several times:

0:50
8:00
8:00
3:00
8:00
2:00
0:30

And then in Excel I want to use the sum function (or the autosum) of all these cells, it returns 0 . When should I return 30:20 .

How could I change the formats from the Visual Studio (now I do it from Excel) to be able to operate with these cells as if they were times?.

    
asked by Isa 18.07.2017 в 09:11
source

1 answer

0

To add it to excel you use SUMA then change the format type to [h]: mm: ss That will give you 30:20

    
answered by 25.07.2017 в 03:03