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/88963.aspxTue, 16 Apr 2013 22:15:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:88963Asfiti0https://www.infopathdev.com:443/forums/thread/88963.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=88963<p>&nbsp;My apologies, the result is in minutes &amp; I need to know how do I convert this into hrs and minutes? any help is appreciated. <br /></p>https://www.infopathdev.com:443/forums/thread/88961.aspxTue, 16 Apr 2013 21:04:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:88961Asfiti0https://www.infopathdev.com:443/forums/thread/88961.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=88961<p>&nbsp;Hi,</p><p>How do I convert whole number to Time?&nbsp;</p><p>E.g. I have Time1: 01:20:00 &amp; Time2: 01:25:00 </p><p>The result should be: 00:05:00</p><p>I used this formula to get Total minutes= 60 * (substring(Later Time, 12, 2) - substring(Earlier Time, 12, 2)) + (substring(Later Time, 15, 2) - substring(Earlier Time, 15, 2)) + (substring(Later Time, 18, 2) - substring(Earlier Time, 18, 2)) / 60 &amp; the result is Total Minutes in wholenumber<br /></p><p>But, I would like to know how to parse from wholenumber to Time or if I get help to subtract directly &amp; displaying in time format?</p><p>Thanks, <br /></p><p>&nbsp; <br /></p>