https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/81131.aspxMon, 30 Jul 2012 18:35:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:81131Mel Clemente0https://www.infopathdev.com:443/forums/thread/81131.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=81131<p>InfoPath can only perform mathematical functions/calculations to fields of number type, e.g. integer or decimal. In your case, the Time field should be of decimal type. I&#39;m thinking you will have to do some kind of conversion, for example, 00:30 should be 0.50, 01:00 should be 1.00, 01:30 should be 1.50, and so on... So that dropdown, change it so that <strong>values</strong> are the decimal conversions, and <strong>display</strong> are the time formats.</p>https://www.infopathdev.com:443/forums/thread/80776.aspxThu, 19 Jul 2012 14:07:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:80776sammyg830https://www.infopathdev.com:443/forums/thread/80776.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=80776<p>Hello</p> <p>I&#39;ve designed a time recording form on a web-browser template for InfoPath 2010.</p> <p>I have a repeating table with a column named time, in time format and a drop down list of length of time at half hourly increments (i.e. 00:30, 01:00, 01:30, etc)</p> <p>I would like to SUM these times up in a text box at the bottom of the form, however using the following formula &#39;NaN&#39; is returned. I have tried changing the text box&#39;s formula to double decimal, time, number and text with no success.</p> <p><strong>SUM(Time)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </strong>[Time&nbsp;is the field in my repeating table]&nbsp;</p> <p>Any direction you could offer would be really helpful.</p> <p>&nbsp;</p> <p>Many thanks</p> <p>Sammy.</p>