https://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/79850.aspxTue, 26 Jun 2012 01:06:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79850Hala7770https://www.infopathdev.com:443/forums/thread/79850.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=79850<p>I didn&#39;t really understand your question, but if I&#39;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?</p>https://www.infopathdev.com:443/forums/thread/79835.aspxMon, 25 Jun 2012 20:01:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79835workin'stiff0https://www.infopathdev.com:443/forums/thread/79835.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=79835<p>Hi everyone,</p> <p>I&#39;m trying to add up a column in a repeating table which contains time values. I&#39;m currently using the following formula, however, it will only utilize the first row of the table in determining the value.</p> <p>&nbsp;concat(substring(100 + number(concat(&quot;0&quot;, substring(aircraftFlightLogIncomingFlightTime, 1, 2))) + number(concat(&quot;0&quot;, substring(flightLogFlightTime, 1, 2))), 2, 2), &quot;:&quot;, substring(100 + number(concat(&quot;0&quot;, substring(aircraftFlightLogIncomingFlightTime, 4, 2))) + number(concat(&quot;0&quot;, substring(flightLogFlightTime, 4, 2))), 2, 2), &quot;:&quot;, substring(100 + number(concat(&quot;0&quot;, substring(aircraftFlightLogIncomingFlightTime, 7, 2))) + number(concat(&quot;0&quot;, substring(flightLogFlightTime, 7, 2))), 2, 2))</p> <p>aircraftFlightLogIncomingFlightTime = a standalone field<br />flightLogFlightTime = time field in the repeating table</p> <p>Thanks!</p> <p>&nbsp;</p>