Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 1 (8 items) Re: Subtracting time problems Thanks for the help Jimmy, but I still can't figure out how to subtract 7.21 from the monTotal field? Posted to General (Forum) by haigaiz on 09-28-2010 Re: Subtracting time problems It's got two views, one for the user to actually see and the other is where it's performing the calculations. The time worked field is where it needs to subtract the 7.21 hours. I've actually got another form that's practically finished but the formatting stuffs up if the make the minutes lower. (bah, i'll zip them both ... Posted to General (Forum) by haigaiz on 09-28-2010 Re: Subtracting time problems The only problem is that the field I need to subtract from isn't a time field. I'm using substring-before to subtract the hours and minutes of each time field into separate Whole Number fields, finding the highest of each and subtracting them, then concatenating them into another field to look like a time field. It doesn't look like ... Posted to General (Forum) by haigaiz on 09-28-2010 Subtracting time problems Hi guys, I'm trying to figure out a way to subtract a constant time value (7.21) from another time value (a Whole Number field that's populated by using substring before's on actual time fields). The problem is when trying to subtract the .21 from a value that's lower than .21 and getting a minus value, instead of subtracting ... Posted to General (Forum) by haigaiz on 09-28-2010 Re: Returning larger number Thanks for that, can't believe I didn't think of that! I'm very new to InfoPath.. I have another question, do you know of a way to do a conditional concat? I want to concat "0" to the start of a number in a textfield if the number is less than 9. So I have a rule setup doing just that, but when I try to preview the form I ... Posted to General (Forum) by haigaiz on 09-28-2010 Returning larger number Hi guys, This is probably an easy one, but does anyone know how to compare two numbers in text fields and return the larger one? Cheers Posted to General (Forum) by haigaiz on 09-27-2010 Re: Converting decimal to time Beautiful! I cannot thank you enough for your help! Posted to General (Forum) by haigaiz on 09-18-2010 Converting decimal to time Hi guys, I was wondering if any of you knew how to convert a decimal number to to time? I'm creating a time-sheet and to find the difference between two times I've converted them to seconds and then subtracted one from the other - then divided the result by 3600. I would like to convert this back to a time format so it's a bit ... Posted to General (Forum) by haigaiz on 09-18-2010 Page 1 of 1 (8 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.