Home / Questions / 276917
Accepted
Sergio David Perez Acosta
Asked: 2020-07-05 23:22:20 +0800 CST 2020-07-05 23:22:20 +0800 CST

How to convert minutes to seconds in a Report Viewer?

  • 772

I need to convert the minutes to hours and minutes. My question is how can I get the hours and minutes in the report instead of getting them in minutes. Here I leave an image, of how the minutes come out at the moment:

enter image description here

If you could help me I would greatly appreciate it. Thank you.

This is the expression that I put in the report to show the total minutes

=Sum(CInt(Fields!sum_minutes.Value))

c#

2 Answers

  1. Best Answer

    In the reportViewer, on the cell that shows the minutes, right click, select "Expression" -> Common Functions -> Date & Time -> hour. For your code it should look like this. =Hour(Sum(CInt(Fields!sum_minutes.Value))) or =Hour(Sum(Fields!sum_minutes.Value)) I have it working in a project.

    enter image description here

    • 1

  2. In the end, in the expression of the Report Viewer I put this expression:

    =Truncate((Sum(CInt(Fields!sum_minutes.Value)))/60)&""& "h :" &" "&((Sum(CInt(Fields!sum_minutes.Value))) Mod 60) &" "&"min"

    • 1