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/94221.aspxSun, 10 Nov 2013 20:25:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:94221wilkies0106aw0https://www.infopathdev.com:443/forums/thread/94221.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=94221<p>&nbsp;If the calculation is already done in the SharePoint list, you could create a form load rule or a query for data rule to set the &#39;total&#39; field as required. <br /></p>https://www.infopathdev.com:443/forums/thread/94185.aspxFri, 08 Nov 2013 15:28:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:94185Becky Hodges0https://www.infopathdev.com:443/forums/thread/94185.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=94185<p>In Sharepoint I have a list created. In the list I have times in a drop-down list using this fomat: 8:30 AM</p><p>I have seen posts without the AM/PM specification; however, I really want to use it.</p><p>I use this calculation and it works beautifully in the Sharepoint list to calculate the amount of time between two times.&nbsp; Where Sun1Out = Stop Time and Sun1in = Start Time.</p><p>=((SunOut1-INT(SunOut1))*24)-((SunIn1-INT(SunIn1))*24)</p><p>&nbsp;I am using Infopath 2010&nbsp;to create my form but it will not take this calculation.&nbsp; How should my formula be written in Infopath or what functions should I use?</p><p>Thank you</p>