Time Difference Between DateTime SSRS Fields

I have two datetime fields and I need to show the difference between them. I used this expression to calculate:

=DateDiff("n", Fields!hra_atncion.Value, Fields!fcha_incio.Value)

The result column should be HH: mm , but the result is a type of long expression. Something like 428011156

Any answer would be appreciated!

UPDATE 11/21/2013

How to get the time difference in minutes between 12-11-2013 20:00 and 14-11-2013 08:00 ?

+4
source share
1 answer

I think you should try this expression:

=Datediff("h",Fields!StartDate.value,Fields!EndDate.value) & ":" & Datediff("n",Fields!StartDate.value,Fields!EndDate.value) mod 60
+5
source

All Articles