Forum Discussion
Solved
Converting Whole Numbers to Time
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 ?
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))
1 Reply
- amitchandak
Super User
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))