Hi All,

I need to get the time difference between two date field in the details section. And then, get the sum of the time difference field.

Sample:
[Details section]

Case# |    Started Date       |    Duration (mins)
01          01/11/2013 09:00              0
02          01/11/2013 10:00              60
03          01/11/2013 12:00              120

[Group Footer]
I would like to show the summary of the duration mins, which will be 180 in this case.

I am using this formula to get the duration
DateDiff("n", Previous({STARTED DATE}), {STARTED DATE})
But I don't think I can use this to calculate the sum of the duration.

My head is hurting ... does anyone have any suggestion how to tackle this situation?
I am happy to change the datediff formula as long as I can get the total duration......

Many thanks!!!

Thanks Sastry for giving me the idea!
My report is looking more hopeful now.

I have added another formula to initialize the variable and put in the Group Footer. Otherwise, it will carry the previous value over.

[Group Header]
Initialize the variable

[Details]
Variable calculation

[Group Footer]
Displaying the variable result

Thanks again!!!!! (and Merry Christmas!!!)