Is there any way to add all the values in a repeating field?

I have one repeating field called "Time Spent" and one called "Total Time." They are repeating because they are being used for progress reports. I want to have the total time be calculated automatically based on the values in the time spent fields. All it needs to do is add all of the values in the time spent field and autoenter that in the total time field.

I guess actually that total time doesn't need to be repeating. I had meant it to be a running total, but it could be a grand total instead. Either way is fine, if someone could tell me if it's possible at all.

TIA,

Carrie

Make the "Total Time" a calculation with the formula Sum(Time Spent). Be sure to set the result as time. Also the field "Time Spent" should be a time field.

Gerd