https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/92485.aspxSun, 25 Aug 2013 23:06:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:92485Patrick Halstead0https://www.infopathdev.com:443/forums/thread/92485.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=92485<p>yes, you&#39;ll need to substring before the time zone. see modified xsn attached.</p>https://www.infopathdev.com:443/forums/thread/92395.aspxWed, 21 Aug 2013 08:58:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:92395Cassie0https://www.infopathdev.com:443/forums/thread/92395.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=92395<span style="COLOR:#333333;FONT-SIZE:10pt;"><font face="Times New Roman"><span style="FONT-FAMILY:&#39;Arial&#39;,&#39;sans-serif&#39;;COLOR:#333333;FONT-SIZE:11pt;"></span><span style="FONT-FAMILY:&#39;Arial&#39;,&#39;sans-serif&#39;;COLOR:#333333;FONT-SIZE:11pt;"> <p>I have a template part with two fields, StartTime and EndTime.&nbsp; They are formatted as time&nbsp;in format 9:46.</p> <p>I have a calculated field&nbsp;(&quot;Total&quot;) that is also fomatted in the same way.&nbsp; The XPath expression for it is...</p> <p>xdDate:AddSeconds(my:EndTime, -1 * (substring(my:StartTime, 1, 2) * 3600 + substring(my:StartTime, 4, 2) * 60)) </p> <p>I type 1:00 for StartTime, and 2:00 for EndTime but the Total is 17:00 when it should be 1:00</p> <p>My computer&#39;s regional settings say that we are (UTC+08:00).It seems like the AddSeconds function is taking 8 hours off my result.&nbsp;</p> <p>Can&nbsp;anyone plases advise on whether this is some sort of bug with the AddSeconds function or how the formula should be written using the AddSeconds function?</p></span></font></span>