Calculate by adding a lot of numbers

[Everton Juniti]

Someone, please help me!!!

How can I calculate by adding a lot of numbers, recorded in a database, even if those numbers are the time type?

I need a script that make this calculation...

Thanks.

[stanley]

Everton:

What exactly are you counting? Minutes? Hours? More detail is needed.

-Stanley

[Lee Smith]

Not sure what you want for a result. FileMaker stores time [color:red]as a Number. However, I'm not understanding what this is suppose to give you?

Maybe you are wanting to add up the results of the elapsed time for several entries.

If you can do this with a calculation, you can do it with a script. I usually work with the calculation in a test calculation field first before trying to get a script to work.

HTH

Lee

[Everton Juniti]

I'll be more specific about what I really want.

I have a lot of records and I'm counting hours, minutes and seconds, adding one by one and make a calculation that returns to me the result of this calculation.

Example:

- 08:12:01 (first record)

- 08:00:02 (second record)

- 08:20:32 (third record)

After calculation, it returns this result:

- 24:32:35 (adding up hours, minutes and seconds)

Thanks to all of you that answered me.

[Søren Dyhr]

Try this way:

--sd

Untitled.zip

[comment]

Or this way?

Untitled.fp7.zip