How do you total time durations in filemaker?

[zingo]

Hi, first post here...

I'm a composer and I'm compiling a cuesheet. It gives information about when a piece of music begins in the show, it's title, composer, name etc...

The way I have it set up right now is that every cue (piece of music) has it's own record. Within that record, one field is for music cue duration.

My last project has 52 music cues and I need to add up those time durations from all the records in the file (52 records). The result field should be in hours, minutes & seconds. Can someone walk me through this? I'm a newbie... I've only created some very basic layouts before with only simple calculations.

Thanks in advance!

Dan-

[comment]

Define a new field as Summary (Total of Duration). If your Duration field is defined as type Time, the summary field will automatically display as time, too.