Bring up the Report Properties (by right clicking outside the report in Layout view)

Now go to the Code tabe and write in this code:

Function MinutesToHoursMinutes(ByVal vMins As Integer) As String

 

Dim Mins As Integer

Dim Hours As Integer

 

vMins = IIF(vMins <= 0, 0, vMins)

 

Hours = Floor(vMins / 60)

Mins = vMins - (Hours * 60)

 

MinutesToHoursMinutes = IIF(Hours < 9, "0" & CStr(Hours), CStr(Hours)) & ":" & IIF(Mins < 9, "0" & CStr(Mins), CStr(Mins))

 

Return MinutesToHoursMinutes

 

End Function

Now Insert this formula into the texbox: