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/75831.aspxWed, 29 Feb 2012 07:41:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:75831Jo-Anne Alfafara0https://www.infopathdev.com:443/forums/thread/75831.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=75831<p>Hi wissems,</p> <p>You can use substring in your formula to get the time on both date time fields and then subtract it. </p> <p>Please see this sample form for tips on how to use substring on date/time fields:</p> <p><a href="http://www.infopathdev.com/files/folders/examples/entry41104.aspx">http://www.infopathdev.com/files/folders/examples/entry41104.aspx</a></p> <p>Thanks!</p>https://www.infopathdev.com:443/forums/thread/75794.aspxTue, 28 Feb 2012 15:23:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:75794wissems0https://www.infopathdev.com:443/forums/thread/75794.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=75794Hi, I have an infopath 2010 form that contains three fields: 2 date time and the 3rd contains the difference between the two in hours how I can make the difference between the two so that the display will be like this: Date Time1 05/01/2010 22:00 Date Time2 6/1/2010 1:00 Diff Field 3:00 thank you in advance for your answer