Scenario – In my SSRS report I have calculate Age field of Tickets like in 1 Day 2 Hours 20 min format and we are getting values in minute .

Solution –

I have created filed called Age(Minutes) in my SP or query

IN SQL –

datediff(minute,date_created, getdate()) as ‘Age (Minute)’

IN SSRS write expression

=  ( Fields!Age__Minute_.Value ) \ 1440 & ” days ” &  ((( Fields!Age__Minute_.Value ) MOD1440) \ 60 ) & ” Hours ” & ((( Fields!Age__Minute_.Value ) MOD1440) MOD 60 ) & ” Minutes “