InfoPath Dev

Dear Friends, I'm using Infopath 2013 and I need convert a decimal number in hour and minutes... for exemple convert 30 in 00:30 convert 75 in 01:15 i tried use this formula concat(substring-before(field, ":"), ".", 100 * substring-after(field, ":") div 60) but its dosent work :(

Hi Rande,

You need something like this; (substring-before(substring-after(field, "T"), ":") * 60) + (substring-before(substring-after(field, ":"), ":"))

Note: this assumes date and time. If it's just try this: substring-before(field, ":") * 60) + (substring-before(substring-after(field, ":"), ":"))

:)