Codehttps://www.infopathdev.com:443/forums/45.aspxenCommunityServer 2007 SP3 (Build: 31118.962)Re: Repeating Section - Format Sum Operationhttps://www.infopathdev.com:443/forums/thread/79748.aspxThu, 21 Jun 2012 17:26:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79748xtremeIX0https://www.infopathdev.com:443/forums/thread/79748.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=79748Worked perfectly; thank you!Re: Repeating Section - Format Sum Operationhttps://www.infopathdev.com:443/forums/thread/79715.aspxThu, 21 Jun 2012 04:22:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79715Jimmy0https://www.infopathdev.com:443/forums/thread/79715.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=79715<p>I believe this should work:</p><p>sum(eval(<u>startTime</u>, &quot;substring-before(., &#39;:&#39;)&quot;))</p>Repeating Section - Format Sum Operationhttps://www.infopathdev.com:443/forums/thread/79707.aspxWed, 20 Jun 2012 21:48:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79707xtremeIX0https://www.infopathdev.com:443/forums/thread/79707.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=79707I have a repeating section with a field called &quot;startTime&quot; containing values in &quot;hh:mm&quot; format and I want the total of all the &quot;hh&quot; to display in another box outside of the repeating section.&nbsp; I know if the &quot;starTime&quot; is a whole number you can say sum(startTime) and it adds&nbsp;all the numbers but,&nbsp;in the format I have for the field I tried sum(substring-before(startTime,&quot;:&quot;))&nbsp; and&nbsp;it doesn&#39;t work.&nbsp; Any ideas?