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/71077.aspxThu, 13 Oct 2011 02:23:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:71077MoBayTech0https://www.infopathdev.com:443/forums/thread/71077.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=71077solved my issue with http://blogs.msdn.com/b/infopath/archive/2007/02/21/calculating-elapsed-time-without-code.aspx <br /> <br /> (((substring-before(endTime, &quot;:&quot;) * 60) + substring-before(substring-after(endTime, &quot;:&quot;), &quot;:&quot;)) - ((substring-before(startTime, &quot;:&quot;) * 60) + substring-before(substring-after(startTime, &quot;:&quot;), &quot;:&quot;))) / 60https://www.infopathdev.com:443/forums/thread/71076.aspxWed, 12 Oct 2011 23:28:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:71076MoBayTech0https://www.infopathdev.com:443/forums/thread/71076.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=71076<p><span style="text-align:left;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;orphans:2;widows:2;font-size-adjust:none;font-stretch:normal;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0px;" class="Apple-style-span">I have two drop down fields<span class="Apple-converted-space">&nbsp;</span><em style="border-width:0px;margin:0px;padding:0px;font-family:inherit;font-style:italic;font-weight:inherit;outline-width:0px;">data type time</em><span class="Apple-converted-space">&nbsp;</span>named TimeIn and TimeOut and another text box field named hours that I want to show the results of the time a user worked.<br style="margin:0px;padding:0px;" /><br style="margin:0px;padding:0px;" />Example:<br style="margin:0px;padding:0px;" /><br style="margin:0px;padding:0px;" />TimeIn = 9:00 AM TimeOut = 5:00 PM then hours = 8<br style="margin:0px;padding:0px;" /><br style="margin:0px;padding:0px;" />I can&#39;t figure how in infopath to calculate the hours field, any ideas on how to solve this issue?</span></p><p><span style="text-align:left;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;orphans:2;widows:2;font-size-adjust:none;font-stretch:normal;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0px;" class="Apple-style-span"></span>&nbsp;</p><p><span style="text-align:left;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;orphans:2;widows:2;font-size-adjust:none;font-stretch:normal;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0px;" class="Apple-style-span"><span style="text-align:left;text-transform:none;text-indent:0px;letter-spacing:normal;word-spacing:0px;white-space:normal;orphans:2;widows:2;font-size-adjust:none;font-stretch:normal;-webkit-text-decorations-in-effect:none;-webkit-text-size-adjust:auto;-webkit-text-stroke-width:0px;" class="Apple-style-span"><img title="Timesheet 1" alt="Timesheet 1" align="middle" src="https://lh4.googleusercontent.com/-8R5aLyJlxTw/TpYnxUswQYI/AAAAAAAAAMc/YJ069NNecQ8/s512/ts2.jpg" /><img style="width:624px;height:113px;" title="Timesheet 2" alt="Timesheet 2" src="https://lh3.googleusercontent.com/-6ZGgYxhFdaY/TpYnwFAEUAI/AAAAAAAAAMU/cMSk7W8newU/s801/ts1.jpg" width="801" height="145" /></span></span></p>