Re: convert decimal to time

Patrick Halstead — Mon, 18 Apr 2016 12:39:42 GMT

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, ":"), ":"))

convert decimal to time

rande — Sun, 10 Apr 2016 20:24:41 GMT

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 :(

thanks to help me

Code

Re: convert decimal to time

convert decimal to time