InfoPath Dev

Hi everyone,

I'm trying to add up a column in a repeating table which contains time values. I'm currently using the following formula, however, it will only utilize the first row of the table in determining the value.

 concat(substring(100 + number(concat("0", substring(aircraftFlightLogIncomingFlightTime, 1, 2))) + number(concat("0", substring(flightLogFlightTime, 1, 2))), 2, 2), ":", substring(100 + number(concat("0", substring(aircraftFlightLogIncomingFlightTime, 4, 2))) + number(concat("0", substring(flightLogFlightTime, 4, 2))), 2, 2), ":", substring(100 + number(concat("0", substring(aircraftFlightLogIncomingFlightTime, 7, 2))) + number(concat("0", substring(flightLogFlightTime, 7, 2))), 2, 2))

aircraftFlightLogIncomingFlightTime = a standalone field
flightLogFlightTime = time field in the repeating table

Thanks!

I didn't really understand your question, but if I'm getting you right, this rule calculate the time and sets the value to a column in the repeating table, and it just do it for the first row of it, am I seeing it right?