SUM Duration

[#1]

Hi,

pls can any body tell me how to get the sum of duration

for eg:

00:01:02

00:00:03

and the sum will be 00:01:05

Duration is a field in the database.

Thanks & Regards,

Arun

[#2]

sum(Duration)

[#3]

Hi Arun,

The post given above will solve your issue. But when you get it in a list bos, it shows you some decimal value. In order to override this, go to the list box properties and override the dimension with time format. Or you can do it in the script part by specifing the format fot the time. That is like given belo:

Sum(Time)

and then Time(timefeild,'HH:MM:SS')

hope this solves your issue.

Thanks Joseph.....

[johnw]

If Duration is a formatted interval of time, sum(Duration) appears to preserve the formatting. If you have to format it manually for some reason, use interval instead of time. Time is the time on a clock, like 8:00 AM, not a duration of time. Interval is used for a duration of time, like 8 hours.

[#5]

You Can Try this.

Interval (Sum([Duration]))

Regards.
Tonial.