Using Report Builder 3.0, I wrote a pretty basic report that was just a little too complex to accomplish with the report wizard in CRM. I'm using the DateDiff function to calculate the time between two dates, in seconds. I want to display this in a new column in dd:hh:mm:ss format. I am able to accomplish hh:mm:ss, but dd:hh:mm:ss doesn't want to work for some reason when I first divide by 86400 and adjust the rest of this formula accordingly.
=int(sum(Fields!Seconds.Value)/3600) & "h: " & int((sum(Fields!Seconds.Value) Mod 3600)/60) & "m: " & (sum(Fields!Seconds.Value) Mod 3600) Mod 60 & "s"
*This post is locked for comments
I have the same question (0)
