Home Forums Reporting Services Reporting Services How to convert decimal numbers to Hours and minutes RE: How to convert decimal numbers to Hours and minutes

  • April 1, 2014 at 3:47 am

    #1701930

    the above question aside, based on what you asked for the following appears to work

    =format(int(ReportItems!MyDecimalTotal.Value) + int(round(reportitems!MyDecimalTotal.value mod int(reportitems!MyDecimalTotal.value),2)*100)/60,"000") + " hours " + format(round((ReportItems!MyDecimalTotal.Value - int(ReportItems!MyDecimalTotal.Value))*100,0) mod 60,"00") + " minutes"