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/101573.aspxFri, 06 Mar 2015 16:50:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101573Caeanis0https://www.infopathdev.com:443/forums/thread/101573.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101573<p>I have a form that calculates the number of minutes for a given project.&nbsp; Some may only take minutes, some hours, some several days.&nbsp; I am wondering how to take an integer or double and return the corresponding days, hours, minutes etc. <br />I have seen several posts that explain how to do the reverse which is convert date picker values to a number but I&#39;m not sure how to go about this the other way.<br /><br />I think the basic logic would be:<br />Round the double up to an integer:<br />floor(Double)<br />If this result is greater than 1440 (minutes in a day)<br />days = floor(Double)/1440<br />hours = ((floor(Double)/1440)-1140)/60<br />minutes = (((floor(Double)/1440)-1140)/60)-60<br /><br />Not quite sure if this is right, and not sure how to write this formula. Any help would be appreciated.<br /><br />Marc<br /></p>