combine two number columns in new custom column

[AndyValente]

Hello, I am trying to combine the content of two columns containing number values.

=[hour] & ":" & [min]

doesn't work, as such operation is not allowed with number columns. I have looked around but was not able to find an answer, any advice? Thank you

[tjd]

I don't think you can concatenate numbers.  Try converting Hours and Minutes to text type and then it should work.

[MarcelBeug · Accepted solution]

You may want to get:

• A time value: #time([Hour],[Min],0)
• A duration: #duration(0,[Hour],[Min],0)
• Texts with leading zeroes (e.g 01:05): Text.PadStart(Text.From([Hour]),2,"0")&":"&Text.PadStart(Text.From([Min]),2,"0")

[AndyValente]

Thanks, after solving the first issue, I was facing the problem of having the wrong hour and minute format in the end, so your code was really helpful.