Home / Questions / 276645
Accepted
Sergio David Perez Acosta
Asked: 2020-07-05 03:22:49 +0800 CST 2020-07-05 03:22:49 +0800 CST

How to remove the days when I do a TimeSpan.FromMinutes in C# Report?

  • 772

I have a report in C# of totals where I add the minutes that a worker who has worked a series of hours, but nevertheless in the expression if the worker has spent more than 24 hours working it adds the days. I don't want the days to show but the total hours. Here I leave the code of the Expression and the image to corroborate that the days come out. enter image description here

and the expression code. Thanks for your attention.

TimeSpan.FromMinutes(Sum(CInt(Fields!suma_minutos.Value)))

According to what they told me, it appears like this:

enter image description here

c#

1 Answers

  1. Best Answer

    Since rdlc is a bit limited, I would recommend adding a new field, for example suma_minutos_str, and initializing it as follows:

    var tmsp = TimeSpan.FromMinutes(suma_minutos); //aqui en suma_minutos el valor que has calculado
var suma_minutos_str= $"{tmsp.Days*24+tmsp.Hours}:{tmsp.Minutes.ToString("00")}:{tmsp.Seconds.ToString("00")}";

    In this way suma_minutos_str, you have a string in which the days multiplied by 24 are added to the "loose" hours, and the minutes and seconds are added. Then, it is that variable that you must use in the RDLC.

    • 2