Expand my Community achievements bar.

time calculations

Avatar

Level 2

I have designed a form with a expanding table. There are three time fields startTime; endTime and TTime. TTime calculates startTime and endTime in "HH:MM" and it works just fine. However I need to sum the TTime field of each row. I cant seem to get a script that works.

Leave Register.png

1 Reply

Avatar

Level 8

Either on the TTime script set the Total by using the same method you're already using to get the TTime.  Total + TTime.  If you put the calc on the Total field then you'll have to iterate through the table to get the TTimes.