none
How to get the number of hours from a minutes column in rdl reporting RRS feed

  • Question

  • Hi All. I have this expression to find how many hours and minutes used,  

    =("HOURS USED: " & SUM(Fields!HoursWorked.Value) + CINT(SUM(Fields!MinutesWorked.Value MOD 60) / 60) & "H " &  (SUM(Fields!MinutesWorked.Value) MOD 60) & "M ".

    But it adds total hours by 1 hour. I have two columns on my table, namely hours worked and minutes worked. Please assist by identifying what is wrong or if you have a better expression. help will be appreciated, thanks.

    Friday, August 15, 2014 8:26 AM

All replies

  • I finally figured it out guys, i made some changes (Bold) and it worked.

    = "HOURS USED: " & SUM(Fields!HoursWorked.Value) + (SUM(FIELDS!MinutesWorked.Value) - (SUM(FIELDS!MinutesWorked.Value) MOD 60))/60 & "H " &  (SUM(Fields!MinutesWorked.Value) MOD 60) & "M ".

    Friday, August 15, 2014 2:29 PM