SSRS Custom code to convert the Integer values into “Days:HH:MM” format

To Convert the Integer values into “Days:HH:MM” format:

Write the following VB.Net code in Custom Code area (Right click on report -> Report Properties -> Code)

Function MinToDDHHMM(iValues  as integer) as String

        Dim mDay,  iHour As Integer

        Dim mMinute As Integer

 If mValue >= (24 * 60) Then

            mDay = mValue \ (24 * 60)

            mValue = mValue Mod (24 * 60)

 End If

 If mValue >= 60 Then

            mHour = mValue \ 60

            mValue = mValue Mod 60

  End If

mMinute = mValue

MinToDDHHMM = IIF(mDay>9,iDays, "0" & mDay) &  ":" & IIF(mHour>9,mHour, "0"&mHour) & ":" &

                                                        IIF(mMinute>9 ,mMinute,"0" &mMinute)

End Function

Now, use the following value expression “ =Code.MinToDDHHMM(Fields!TotalMinutes.Value) in the report area.

(Considered that the field “TotalMinutes” contains the minute value to be converted into Days:HH:MM format.)

Result : You will get the minute value “1505” as “01:01:05”