Converting Whole Numbers to Time

[dymetre973]

Im trying to convert these whole numbers to HH:MM formnat but get an error when trying to convert using the default in tools in Power Query .

Any help with being able to convert this ?

[amitchandak · Accepted solution]

@dymetre973 , On way it use it duration

#duration(0,0,[column],0)

Another create manually

Number.ToText( Number.IntegerDivision([Column],60))  &  ":" & Number.ToText( Number.Mod([Column],60))